Compare two lists of names
 

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

Compare two lists of names
 

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.

"ea" wrote:

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