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