Separating strings into different columns from one cell

[Melanie O]

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

 

[cmart02]

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

 

[Bob Phillips]

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

--

HTH

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