text to row

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

Guest

How do I convert text within a cell to multiple rows in the same way that I
can convert each word to multiple columns with the text-to-column function?

-Excel 2000
 
Try the text to column function, select the text in the columns, copy to the
clipboard, then use the paste special function - transpose option. This will
put the info in one column but different rows.

If that works, you might want to develop a macro.
 
Back
Top