How to move lots of data from a cell to multiple lines [SOLVED]

**hjsf** · 03-16-2009, 11:30 AM

Hello. I have a problem that i don't know how to solve. I have one cell with values like this:

127;71;512;458;1250;722;2154;742;29;350;

and what to put in lines like this:

127
71
512
458
...

Has i have a lot of data in the cell and everyday it changes, i take several hours doing it manually. I have tried using the command data/ text in colluns but because i have huge data it leaves a lot out. Do you have any idea how to put that values in lines automatically?
Thank you

**DonkeyOte** · 03-16-2009, 11:36 AM

You could try using VBA method perhaps ?

Below assumes string to split & transpose is A1

Please Login or Register  to view this content.

Change references to suit.

**martindwilson** · 03-16-2009, 11:42 AM

or non vba
copy into word
find replace ; with ^p
then copy paste back into excel

**hjsf** · 03-16-2009, 12:10 PM

VBA method seems nice, i will use it in the future.

I replaced ; with ^p and it worked in perfection. Thanks so much.
I registered today and you already discovered the solution for a problem i was trying to solve for months.
THANK YOU from Portugal.

))

**shg** · 03-16-2009, 05:34 PM

Rather than marking threads as solved by appending Solved to the title, please do it like this:

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes