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 |
All times are GMT +1. The time now is 11:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com