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