Reversing First & Last Name

M

Magic

Joe Brown is the text in a cell. Is there a worksheet function that I can
turn this into Brown, Joe in another cell.
 
A

Alan Perkins

One way:
Assuming you have the name in cell A1...

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

Domenic

Assuming no middle initials, try...

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

Hope this helps!
 
Top