Separating strings into different columns from one cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Back
Top