How to open up 50 text files in 1 worksheet in fewest moves?

U

UCI_guy

I need to open up 50 text files and merge them into a worksheet (in less than
50 moves)?
 
D

Dave Peterson

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.
 
Top