Do the following:

1) Select the cell, go to Data--Text to columns and select comma as your
delimiter.

2) Copy the horizontal range, select paste special, transpose.

Dave
--
Brevity is the soul of wit.


"Moss" wrote:

I have tons of random #'s in one cell seperated by commas.

For example: In one cell--03, 04, 05, 06, 07, 08, 09, 10, 11, 14, 15, 2, 3,
41, 51, 52, 53, 57, 61, 63, 68, 75, 80, 81, 84, 85, 87, 89, 91, 94, 95, 97

How can I display the data vertically in seperate rows for each # without
doing it manually?

Please Help!