help with picking country code from list of email addresses

[allaud]

Hi,

appreciate if someone can help.

I have a list of email address's in col A format of email add is [email protected] or [email protected] where my = country code for Malaysia and us for USA etc.
I want a formula to search for particular country code eg. @my and when found write my in col b which has col heading of country code.

sample data in attached spreadsheet.

[NBVC]

Try:

=MID(A2,FIND("@",A2)+1,FIND(".",A2)-FIND("@",A2)-1)

copied down