Last, First Name Swap

[LaramieHartmann]

I've got two spreadsheets with names that I am trying to compare. Bot
have full names stored in one field. One has normal FirstName Lastnam
the other Lastname, Firstname.
With about 2000 names to compare it's not going to be easy. Is ther
anyway to swap the names so they are goth FirstName Lastname or vic
versa? Thanks

 

[J.E. McGimpsey]

one way:

=TRIM(MID(A1,FIND(",",A1)+1,255) & " " & LEFT(A1,FIND(",",A1) -1))



You might also want to check out

http://cpearson.com/excel/firstlast.htm