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

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

"hellison" wrote:

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

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)

"hellison" wrote:

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