View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] cerezoluis@gmail.com is offline
external usenet poster
 
Posts: 3
Default 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