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 ","
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.