View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Conan Kelly Conan Kelly is offline
external usenet poster
 
Posts: 419
Default 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