Hopefully simple Excel problem

[.Griff.]

All,

I have a massive (13mb) txt file in the following format -

abcdefg,abcdefg,abcdefg,abcdefg,abcdefg, and so on in a massive line..

I would like to view it in Excel vertically, i.e -

abcdefg,
abcdefg,
abcdefg,
abcdefg,

That way I can compare it to another column using countif.

Any obvious way of taking a long string of text and using the comma as a separator turn it into a column?

Hope that makes sense.

 

[danlightbulb]

2 steps.

First you need to import the data using the comma as the delimiter.

Second you can select the whole data range and in another sheet use paste special and select the transpose tick box.


I'd guess a vba macro would be needed to do it in one step.

 

[.Griff.]

Thank you!