Hopefully simple Excel problem

Soldato
Joined
16 Apr 2004
Posts
3,892
Location
Shropshire
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.
 
Last edited:
Back
Top Bottom