Changing text in a cell from last name first to first name first.

[hellison]

I am trying to change the data in a column from last name first to first name
first.

Example Doe, John to John Doe

Thanks

 

[Mike H]

This was posted recently by Teethless Mama (Apologies if it was someone
else). Can't find the post but I did copy it:-

=IF(LEN(A1)-LEN(SUBSTITUTE(A1," ",""))=2,RIGHT(A1,LEN(A1)-FIND(" ",A1,FIND("
",A1)+1))&", "&LEFT(A1,FIND(" ",A1))&" "&MID(A1,FIND("
",A1)+1,FIND("",A1,FIND(" ",A1)+1)-FIND(" ",A1)),RIGHT(A1,LEN(A1)-FIND("
",A1))&","&LEFT(A1,FIND(" ",A1)-1))

Mike

 

[Toppers]

in a "helper" column (say B):

in B1:

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

Copy down

Copy/Paste Special to get values (remove formula)