Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing a text file | Excel Discussion (Misc queries) | |||
Importing CSV file (saved as Text) into XL as Text -- over 60 colu | Excel Discussion (Misc queries) | |||
Importing text file, only option to edit existing file | Excel Discussion (Misc queries) | |||
Importing a text file | Excel Discussion (Misc queries) | |||
Help Importing Text File! | New Users to Excel |