Need to separate and rearrange names
You were lucky, I was about to write to my MP <bg
--
HTH
Bob
"Nadine" wrote in message
...
That was supposed to say Bob Phillips' post worked perfect.
"Nadine" wrote:
This leaves lots of extra space between the two names. Gord Dibben's
formula
worked perfect. Thanks for taking a stab at it though. I appreciate it.
"Teethless mama" wrote:
=MID(A1&" "&A1,FIND(",",A1)+1,LEN(A1))
"Nadine" wrote:
How do you take Last,First and change it to First Last?
Ex: Joe,John needs to be rewritten to John Doe.
Using Excel 2003 and having the formula be in a different cell than
the text
it is converting so that the original text remains unchanged.
|