Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Merging text files with excel
Hello All.
How can I merge several text files with the same format into one Excel sheet in one go ? I am importing them singly but it would be much better to merge them together before opening. Many thanks for any help ! |
#2
|
|||
|
|||
Maybe you can use some old DOS commands.
Shell to a command prompt and issue an old DOS command to concatenate the Text files. Windows start button|Run (or flying windows r as a shortcut!) win98: Command WinXP/NT: CMD Go to that folder: C: (to change to that drive) cd\myfolder1\myfolder2\myfolder3 to change to that folder copy *.txt All.Files Ren All.Files All.Txt (if you used All.Txt, then the copy command would try to include the total file into itself--and you'd get an error. So we copy all the .txt files to .files and then just rename the .files to .txt) Exit to quit the shell. Then import all.txt into excel. SpaceMax wrote: Hello All. How can I merge several text files with the same format into one Excel sheet in one go ? I am importing them singly but it would be much better to merge them together before opening. Many thanks for any help ! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I import several text files into excel or access ? | Excel Discussion (Misc queries) | |||
setting text qualifier in Excel | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
multiple text files URGENT | Excel Discussion (Misc queries) |