| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I join multiple excel files into 1 file?
Hi,
I have hundreds of excel files under 1 folder with exactly same # of columns and same column names in each file, e.g. file1.xls, file2.xls, file3.xls, ..... file100.xls. Just wonder if there is a way in Excel (2003) to merge or concatenate all these similar files into 1 new-big excel file so I can do analysis over this 1 file instead of 100 files??? Thanks in advance!!! John Lin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Putting Excel formatting and/or formulas into CSV file | Excel Discussion (Misc queries) | |||
| Importing multiple Text files into Excel 2003 | Excel Discussion (Misc queries) | |||
| Exporting from Excel to multiple XML files | Excel Discussion (Misc queries) | |||
| Opening an Excel file | Excel Discussion (Misc queries) | |||
| Excel 2003 Opens Up Every File in My Documents | Excel Discussion (Misc queries) | |||
Threaded Mode
