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

In article ,
LaramieHartmann
wrote:

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