importing multiple text files into Excel with corresponding filenames

  • Thread starter Thread starter avi
  • Start date Start date
A

avi

Dear members,

I need to import 100+ text files into Excel.

In addition I want EACH Excel column to show corresponding filename
too (where the data comes from).

How do I accomplish this?
TIA
 
Correction:

In addition I want EACH Excel ROW to show corresponding filename
(where the data comes from).

instead of
.... EACH Excel column ....
Click to expand...

Files are comma delimited
 
Back
Top