Text in Excel

[Amanda]

I am trying to switch the order of words in a cell. For
example I would like to switch "John Doe" to "Doe, John"
in the cell next to the original. Is there any way to do
this using a function? Please help!!!

 

[Dan E]

Amanda,

Here's a formula that will do it.

=RIGHT(A29,LEN(A29)-SEARCH(" ",A29)) & ", " & LEFT(A29,SEARCH(" ",A29)-1)

Note: Will only work for First Last style names. If you
have names like Bill L. Johnson you'll get results like
L. Johnson, Bill.

Dan E