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

Parsing cells to reformat a multi-entry field database 2
Replace a comma with a period in a cell containing a lastname, firstname, middle i 2
replacing comma with another symbol 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Inserting a Copied Row inside a table 6
Separating a comma separated list 3
Need help with getting comma-separated values 0
Replacing carriage returns with a comma 4

Top