TO SEND take 2.xlsxHiya, I have tidied up my mess and you will see on sheet2 my idea behind the lists.

Things that do not work:

1 I can't get the entity LOOKUP formula to respond.
2 Names, please see highlighted in yellow as an example.
3 Advice on how to search for the bad words formula.
4 Company name - looks ok??

Regarding, whether its a surname or not there is no way to really tell, but I would like it to return a best guess first name for instance, as per my list.

I think I'm nearly there, thanks to you!! :D