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

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?