Text in Excel

  • Thread starter Thread starter Amanda
  • Start date Start date
A

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!!!
 
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
 
Back
Top