Flipping the order of words in a column to a new column

R

rachel

If you have one column that reads Jane Doe can you easily reverse the order
to read Doe Jane by creating a formula?
 
B

Bondi

rachel said:
If you have one column that reads Jane Doe can you easily reverse the order
to read Doe Jane by creating a formula?
Click to expand...

Hi Rachel,

If there is only first and last name and they are all seperated by a
space you can use something like this:

=RIGHT(A1,LEN(A1)-FIND(" ",A1,1))&" "&LEFT(A1,FIND(" ",A1,1))

Regards,
Bondi
 
R

Ron Rosenfeld

If you have one column that reads Jane Doe can you easily reverse the order
to read Doe Jane by creating a formula?
Click to expand...

For a two word separated by a space phrase in A1:

First Word: =LEFT(A1,FIND(" ",A1)-1)
Second Word: =MID(A1,FIND(" ",A1)+1,255)
--ron
 
Top