Using A .TXT File In Excel

Excel spreadsheets (.xls)

In my last post, I looked into using a DOS or CMD program to list all files in a given directory. That worked out well and it generated a .txt file that you should be able to use if you’re able to use the other functions that I’ve discussed on this blog. So let’s give it a start. First off, to answer a question, yes you can open .txt files in excel. You simply click on “file/open” and then select all files:

Then, you’ll be asked if you want to convert the information into columns. Sometimes, especially for some .csv files, that can work. But in this case I’ll just click on finish which will give me the result:

Depending on what I’ll be doing, I could need to combine this and other lists but it’s important to have the full path for each file. How? Simply by going into cell G8 and using:

=”L:/ETF Mmaking/Pete/Hist/” & F8

This is the result:

Then, I could simply write a macro that would go through each of the files with a loop for example to do search and replaces, add a logo or anything else:)


Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss


3 Feedbacks on "Using A .TXT File In Excel"

Hmm it appears like your blog ate my first comment (it was super long)
so I guess I’ll just sum it up what I submitted and say, I’m thoroughly enjoying your blog.
I as well am an aspiring blog writer but I’m still new to
the whole thing. Do you have any tips for first-time blog writers?
I’d certainly appreciate it.


I visited various websites except the audio quality for audio songs present at this site is in fact fabulous.

discounts vouchers for london attractions

discounts vouchers for london attractions

Using A .TXT File In Excel | Experiments in Finance