It's no harder than the previous two time that you asked it.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Levi" wrote in message
...
This seems very easy right? Well, the name list that I am currently
converting is a little querky. I would like to do this---- Cell.A1
[Smith,
John] Cell.A2[John Smith]
Here is hwere it gets a little tricky....I need to nest the TRIM function
to
remedy extra spaces incurred by the data input girl. I would also prefer
to
use the RIGHT, LEFT functions in place of the MID function. I would really
appreciate any advice I could get out there. A friend told me it can be
done
but cannot remember the formula..
THANK YOU