splitting text into rows.

Hi all,

I'm new to VBA and I'm looking for a macro which would do the following:

I have this:

555545, 4555
42225, 44
4444, 5, 4445, 88, 986

and I want this:

555545
4555
42225
44
4444
5
4445
88
986

Many thanks in advance!

This worked perfectly! Thank you very much. What if the list doesn't start from A1 and starts from A5?

Thanks again for your prompt response. Another question related to this topic. What if I would like to do this for multiple columns, A, B & C all at once?

FWIW:

Please Login or Register  to view this content.

Thanks but this is not what I was looking for. The Macro provided by John H. Davis moved all the values to Column A.

This is what I have:

115, 54	454, 245, 5454	545
45, 548, 855	45	10, 11
45, 5	2	3, 4

And this is what I want:

115	454	545
54	245	10
45	5454	11
548	45	3
855	2	4
45
5

This is not working for me . I might have to edit it based on the way my data is set up. Could you explain what Cells(5,i) is referring to?

Thanks!

@stnkynts - Thanks for your explanation. But unfortunately, the code is not working for me. It is only inputting one value for cell A5; and all other cells (A1:C3) remains the same.

@stnkynts and/or @walruseggman - Can you write similar to what @walruseggman had provided earlier?

Thanks!

@stnkynts - This worked perfectly! Thank you!