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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

mporting multiple text files into Excel with corresponding filenames 11
Merging from an Excel file with graphics 1
Importing multiple text files and getting certain figures. 3
Formatting Text from Excel 1
When importing text field Excel chops off leading spaces 3
Linking data in MS Word into Excel 5
Importing files 2
Find & Copy Files Listed in Excel Worksheet ? 2

Top