Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing multiple Text files into Excel
Hi everybody!
I have lots of txt files with a single column of data like this: 101- C 102- C 103- I 104- C 105- I .... etc. I'm looking for the way to put these text files together into a single Excel table which looked like this: Filename1 Filename2 Filename500 101- C 101- I 101- I 102- C 102- C 102- C 103- I 103- C 103- I 104- C 104- I 104- C 105- I 105- C 105- I .... ... ... etc. etc. etc. I would extremely appreciate it if any of you guys could help me put the files together with the name of each file at the top of each column. I haven't got much experience with Excel, but I know how to paste a macro into a module in the Visual basic editor. THANK YOU SO MUCH!!! luis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing multiple Text files into Excel | Excel Programming | |||
Importing from multiple text files | Excel Programming | |||
importing multiple text files into the same worksheet | Excel Discussion (Misc queries) | |||
Importing multiple Text files into Excel 2003 | Excel Discussion (Misc queries) | |||
importing multiple text files??? | Excel Discussion (Misc queries) |