Pasting comma delimited data

  • Thread starter Thread starter OnTheEdge
  • Start date Start date
O

OnTheEdge

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

??
 
OnTheEdge said:
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

??
Click to expand...

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.
 
How many such numbers are there?
If you are using Excel 2003 and you have less than 255 numbers then
Use Text to Columns to separate them into Columns
Select the numbers Copy and PASTE SPECIAL|Transpose on the row below
 
Back
Top