Flipping a last name comma first name in the same cell
Hi,
If it must be in the same cell then that's a macro so post back but if an
adjacent cell will do try this for a name in a1
=MID(A1,SEARCH(" ",A1)+1,LEN(A1))&" "&LEFT(A1,SEARCH(",",A1)-1)
Mike
"Tina Marie" wrote:
Hello ...
Does anyone know how to flip last name and first name
e.g. Robinson, Tina to Tina Robinson in the same cell
--
Thanks!!
T. Marie
|