Flipping a last name comma first name in the same cell
Tina Marie,
Then you could copy from the results of the formula Mike H provided, and
paste special as values into the original cell, then delete the formula.
HTH,
Conan
"Mike H" wrote in message
...
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
|