Reversing order of text

S

Sonics

Within a cell, how do I reverse the position of a last name, first name to
first name then last name? Ex: Doe John to John Doe or Doe, John to John Doe.
 
G

Gary''s Student

For names including a comma, use:
=MID(A1,FIND(", ",A1)+2,255) & " " & LEFT(A1,FIND(",",A1)-1)
For names without a comma, use:
=MID(A2,FIND(" ",A2)+1,255) & " " & LEFT(A2,FIND(" ",A2)-1)
 
E

Eduardo

Hi,
In an adjacent cell enter

=TRIM(RIGHT(D9,FIND(" ",D9)+1))&","&TRIM(LEFT(D9,FIND(" ",D9)))

change range to fit your needs
 

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

2 rows of information, need to move to 1 row 1
LAST, FIRST to First Last 4
Countif. 1
SUMIF & IF 5
Suppressing the top grid line of a cell - 2007 Excel 1
alpha numeric sorting 2
Seperate last name from a cell with full name 3
looking for help again 1

Top