Assuming no middle initials, try...

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

Hope this helps!

In article ,
"Magic" wrote:

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