separate text in one cell into more than one cell

  • Thread starter Thread starter Stephanie
  • Start date Start date
S

Stephanie

How do I separate text that is all in one cell into
different cells. (for exp - separating a sentance that is
all in one cell into each word being in a separate cell)
I have over 600 rows, and I remember at one time using a
formula to do this, but can't remember which one.
 
Stephanie

Have a look at Data>Text to Columns using space-delimited. May do what you
want very quickly depending upon how your text is laid out..

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Back
Top