Replacing a comma ( ,) with a new row

S

spiderweb

Hellol everyone, I have being working ont this spread sheet for a long
time because my work requires that I incert a number in a single cell
in a new row. But some of the cells containt hundreds of numbers
separated with a comma and this makes my life hell.

I would like to know if there is any way I can automatically replace
the comma with a new row.

If anybody can help me out please email me at [email protected].
Thank you very much.
 
G

Gord Dibben

For any cell with less than 256 numbers you should be able to use Data>Text to
Columns>Delimited by>Comma.

When that is done, select the row and Copy>Paste Special>Transpose.


Gord Dibben MS Excel MVP
 
Top