It's a mess as it is hey!!!

What I want to achieve: from the email address, tell me First Name, Company Name, Entity, Country. Also mark cells containing certain "bad" words to be removed.

So 3 phases I suppose.

1 Break the email address up into certain segments. i.e. Name (before the @), domain (PROPER after @), Country Suffix (bit after the last dot, i.e. .co.uk = ".uk"), Entity suffix, i.e. .ac, .gov after the @.
2 Create lists to LOOKUP. As already done with the counties in sheet2.
3 Formulas
Countries: nearly there just need to make it look up after and including the last dot.
First Name: need to make database and import to a list. Can return the same value as the SEARCH. Will this have alphabetical problems?
Company name: To return the bit after the @ and before the next dot. Unless it contains certain words. i.e. Gmail, Hotmail, Yahoo.
Entity: To search the bit after the @ and look for .ac, .gov etc.
Unwanted emails: If the email contains for instance "unsubscribe" in the cell. Mark it so I can bin it.

I would like to add all my lists like the country one to sheet2 so as and when I can easily add to it.

Does this make sense?!

Excited to get this working!