Pasting comma delimited data
OnTheEdge wrote:
Anyone know of a function to paste comma delimited data that looks like this:
1,2,.3,4,5
into rows like this:
1
2
3
4
5
??
First, paste the data into a cell. Then use Text To Columns with comma
delimited to split it into individual cells. Then select all of the cells and
Copy. Select the first cell where you want the rows to start and Paste Special
/ Transpose.
|