This is if info is in A1 and there is a space between first and last
=RIGHT(A1,FIND(" ",A1))& ", "&LEFT(A1,FIND(" ",A1))
--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.
"Todd Taylor" <Todd
wrote in message
...
I'm trying to flop names in a cell from First Last to Last, First