importing multiple text files into Excel with corresponding filenames

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
 
A

avi

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
 
Top