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