close
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.
quot;Brettquot; wrote:
gt; How do I convert text within a cell to multiple rows in the same way that I
gt; can convert each word to multiple columns with the text-to-column function?
gt;
gt; -Excel 2000
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.
quot;Brettquot; wrote:
gt; How do I convert text within a cell to multiple rows in the same way that I
gt; can convert each word to multiple columns with the text-to-column function?
gt;
gt; -Excel 2000
全站熱搜
留言列表
