Hi,

though I'm not sure how you want to deal with cases like .co.za.edu

That was a fake email, the .ac, .gov. and .edu representing the entity are in this format

email@email.gov.za / .ac.za and just .edu (no country representation) - so I'm quite happy with the last two letters replresenting the country. in the case of .edu, I can make "du" return a blank.

First Names!

Good points! I would like it to search the string from the left finding the longest word. Will this work with balexander@email.gov.za - returning Alexander?

Excited to put this all in place now! Just some fiddling to go!

Thinking ahead, with my LOOKUP lists can I make the ranges longer than needed so I can add to the bottom, i.e. if a new country gets added. Then I just have to manually sort - right?

When I paste my long list of emails into column A when this is ready do I just copy the formulas down, or is there an automated way to do it if the cell in row A is not blank? (prob just over complicating it!)

Thanks so much! Looking forward to getting this sorted!