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

G

Guest

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
 
G

Guest

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
 
G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

LAST, FIRST to First Last 4
Reversing order of text 2
Search two columns in list for first and last name and return Id 4
change first name last name to last name first name 3
complicated text to column 4
Matching Names 5
Converting Text Format from LAST NAME, First Name to First Name La 3
Excel Comparing two columns 1

Top