Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to open up 50 text files in 1 worksheet in fewest moves?
I need to open up 50 text files and merge them into a worksheet (in less than
50 moves)? |
#2
|
|||
|
|||
Shell to a command prompt
windows start button|run cmd (in winXP and WinNT) Command (in win98) Traverse to your folder that contains those 50 text files. If they're not in a dedicated folder, create a new folder and copy them there. Then type this: copy *.txt Giant.All (and you'll have one giant text file named Giant.All) Then back to excel and file|open, point at Giant.all and follow the text import wizard. UCI_guy wrote: I need to open up 50 text files and merge them into a worksheet (in less than 50 moves)? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't open existing files by double-clicking. | Excel Discussion (Misc queries) | |||
sometimes cannot see existing worksheet when i open it without full screen toggled on | Excel Discussion (Misc queries) | |||
Can not open excel files without open application | Excel Discussion (Misc queries) | |||
Select Text Files from Combobox | Excel Discussion (Misc queries) | |||
importing multiple text files URGENT!!! HELP | Excel Worksheet Functions |