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

"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

??