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

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

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

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

"rachel" wrote:

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

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

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

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

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

On Fri, 21 Jul 2006 07:41:03 -0700, rachel
wrote:

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

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