change first name last name to last name first name

D

Doris smith

I need to change a column that has first name first and last name last to:

last name first, first name last
 
R

Roger Govier

Hi

Assuming your data is in column A and the names are separated by a space
then in column B enter
=MID(A2,FIND(" ",A2)+1,99)&" "&LEFT(A2,FIND(" ",A2)-1)
Copy down as far as required.
Then, copy column B and Paste Special>Values to fix the data.

If your data is separated by a comma, then insert a comma between the double
quotes in both instances
in the above formula ","
 
S

Stefi

If you have always two name element separated by one space then, the name
being in A1:
=MID(A1,SEARCH(" ",A1)+1,256)&" "&LEFT(A1,SEARCH(" ",A1)-1)
Adjust cell reference and fill it down as necessary!

Regards,
Stefi


„Doris smith†ezt írta:
 

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

Top