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!

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!

Moss

If less than 256 numbers in a cell you could use datatext to columnscomma
delimited to break into cells in a row.

Then Copypaste specialtranspose to a column.

Note: 03, 04, 05 etc are not numbers but text.

When you break them out be sure to select those columns in the third step and
designate as text unless you want to drop the leading 0's


Gord Dibben MS Excel MVP

On Thu, 7 Dec 2006 13:43:00 -0800, 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!