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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
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
change first name last name to last name first name 3
Search two columns in list for first and last name and return Id 4
Reversing order of text 2
complicated text to column 4
Converting Text Format from LAST NAME, First Name to First Name La 3
Matching Names 5
How do I change name in single cell from last, first to first last 2

Back
Top