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.

 

[.Griff.]

Thank you!