multiple if statement

Hi guys - please see attached. This is a small cut (100 records) of a dataset of 8,000 records.

I am looking for a formula to be entered in M2 which does the following:

Looks at L2

if L2 contains a numeric value on the end then say "SNN"
if L2 contains a string which is all text values then say "CC"
if L2 says WEBCONNECT then say "WEB"

The third criteria "Webconnect" is a text value so I am unusure how to distinguish this from the second criteria which is someones first initial and surname.

Background.

Col L is a "booking Cancelled by field" - Webconnect mean a booking was canx via web, three letters and a numeric value means canx on site and the rest are contact centre agents inital and surname.

I have been using =SUM(SUMIF(C2:C11,"???"&{1,2,3},D2:D11)) and countif blah blah webconnect previously to get figures but I now need col m to say SNN, CC or WEB.

Thanks for looking.