One way:
Assuming you have the name in cell A1...
=RIGHT(A1,LEN(A1)-FIND(" ",A1))&", "&LEFT(A1,FIND(" ",A1)-1)
"Magic" wrote in message
...
Joe Brown is the text in a cell. Is there a worksheet function that I can
turn this into Brown, Joe in another cell.
|