Paste vertically to Excel cells of horizontal numbers copied from webpage

Hi there,

I Copied the following numbers from a webpage and paste-special as text. I tried to make the numbers placed vertically in contiguous cells by using Transpose command but in vain.

Copied Numbers
211001 , 211101 , 211201 , 211301 , 211503 , 211601 , 211701 , 211801 , 213801 , 214501
211901 , 212001 , 212101 , 212201 , 214001
212305 , 212407 , 212505 , 212609
212701 , 212801 , 212901 , 213001 , 213101 , 213201 , 213301 , 213401 , 213501 , 213601 , 213701 , 214401

The numbers got pasted in A1 B1 C1 D1 in sigle cells.

How can I place the numbers vertically in contiguous cells in a column?

I am using Office 365 Offline



Rgards,
Fazlul

Originally Posted by mfhaq77

Hi there,

I Copied the following numbers from a webpage and paste-special as text. I tried to make the numbers placed vertically in contiguous cells by using Transpose command but in vain.

Copied Numbers
211001 , 211101 , 211201 , 211301 , 211503 , 211601 , 211701 , 211801 , 213801 , 214501
211901 , 212001 , 212101 , 212201 , 214001
212305 , 212407 , 212505 , 212609
212701 , 212801 , 212901 , 213001 , 213101 , 213201 , 213301 , 213401 , 213501 , 213601 , 213701 , 214401

The numbers got pasted in A1 B1 C1 D1 in sigle cells.

How can I place the numbers vertically in contiguous cells in a column?

I am using Office 365 Offline



Rgards,
Fazlul

Hi
Thank you very much
But it is a long process.
Is there any shortcut from the source (from webpage) because
I have to do a lot of operation every time i refresh the page and
there could be single to multiple lines to copy from webpage.

Thanks again

Originally Posted by CK76

Without knowing source. Not really.

There are other methods, but I am not a mind reader and need you to show where the numbers are copied from and how it's structured in your workbook.

Either way, there is no direct method. You'll need some sort of process, be it manual, formula, or coding to process the data for you.

Hi,
Sorry for the inconvenience.
There are login credential issues, so I can't share the page.

Is there any shortcut formula or macro possibility from the XL file I uploaded? Just consider any number of rows in the Column A (after pasting from the source webpage).

Thanks

Originally Posted by kvsrinivasamurthy

Data A1:a4
Formula in C1

Formula:

Please Login or Register  to view this content.

Hi,

Thank you so much for your easy solution.
This is what I was looking for.
You are really a great guy.

Regards
Fazlul

Originally Posted by mfhaq77

Hi,

Thank you so much for your easy solution.
This is what I was looking for.
You are really a great guy.

Regards
Fazlul

Originally Posted by Glenn Kennedy

Was I invisible?

Hi

Yes, your solution was also great
Thanks for the trouble you have taken.

Regards