Open the Text file directly with Excel.

The text to columns wizard will open.

Choose De-limited by and remove any checked options, especially comma.

Next to see what you get.

If OK........Finish.


Gord Dibben MS Excel MVP



On Wed, 30 Sep 2009 09:53:01 -0700, Ralph
wrote:

hi,

i have a massive text file that is nothing more than a series of words
separated by commas, i.e.

dog, cat, ball, clouds, rain

there are probably 20k to 30k entries ...

is there a way i can import this file into excel so that these words are
stacked in 1 column?? i am doing it the file-import way but it pulls only so
many into 1 row, and then i have to copy-paste-transpose, etc... it will take
me 5 years to do it this way lol

PLEASE HELP!

THANKS!!