or both separators in this case, the comma and the space

--

HTH

RP
(remove nothere from the email address if mailing direct)


"cmart02" wrote in message
...
Mel,

Use the "Text to Columns" to do it. Go to Data -- Text to Columns and
then
choose the separator of your text.

This will do the trick better than a formula.

Regards
Robert