Need to separate and rearrange names
Perfect! THank you so much.
"Bob Phillips" wrote:
Try
=TRIM(MID(A1,FIND(",",A1)+1,99))&" "&LEFT(A1,FIND(",",A1)-1)
--
HTH
Bob
"Nadine" wrote in message
...
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.
.
|