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.