Importing a Text File Into 1 Column
 

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!!

Importing a Text File Into 1 Column
 

When you do the import, you should be asked to select either delimited or
fixed width.

you may want to go with fixed width, though you then risk cutting individual
words in half. May be easier than the alternative.

"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!!

Importing a Text File Into 1 Column
 

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!!

Importing a Text File Into 1 Column
 

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??

One way is to first open the file in Word and use
Edit Replace
to change all the commas by paragraph breaks: "^p" without the quotes. You
might want to remove the space characters the same way.

Then save a copy as a text file and open it in Excel.