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.



"Brett" wrote:

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