Separating strings into different columns from one cell
 

Which formula do I use to separate the string

Smith,Bob J

into three separate last name, first name, and middle name columns? There
are 1000 rows and all names will be of variable length.

Last First Middle
Smith Bob J

Thanks,
Melanie

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

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