Great.
Regarding first name can I make it stick with the first name it finds. I know occasionally this will be wrong. So andrebilly@ would return Andre.
Regarding bad words list, assuming it's now definitive as per sheet2 how do I create this? I assume in the same way as previous formulas?
How do I pull the last info from a cell so I just get the last dot plus text? I.e. Pwc.co.za returns .za ? For my countries lookup I need this!
Thanks again
Bookmarks