Compare two lists of names

E

ea

Can you compare two lists of names where one list is last name first and the
other is first name last?
 
N

Nikki

try this formual:
=RIGHT(TRIM(E2),LEN(E2)-FIND(" ",E2))&" "&TRIM(LEFT(TRIM(E2),FIND(" ",E2)))
it will convert First name last name to last name, first name or Visa versa.
then you can compare your lists.
 
Top