mporting multiple text files into Excel with corresponding filenames
Dear members,
I need to import 100+ text files into Excel.
In addition I want Excel to show corresponding filename (where the
data comes from) in each row.
How do I accomplish this?
TIA
|