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

Returns a trailing space......this drops it

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

Vaya con Dios,
Chuck, CABGx3



"Gary''s Student" wrote:

=RIGHT(A1,LEN(A1)-FIND(" ",A1,1)) & ", " & LEFT(A1,FIND(" ",A1,1))
--
Gary''s Student - gsnu200765