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 (e-mail address removed).
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combining row values into one cell while filter is active 6
Create distinct list and separate commas 1
fifty thousand rows 5
How to create a single line separated by commas from a matrix? 2
HELP! Split cell contents to new rows 7
Replace Comma's with Dash 2
Help with loop 4
cell to have comma-delimited values based on text 8

Top