How to Get the List of File Names in a Folder in Excel (without VBA)

In this video, I will show you how to get a list of file names from folders into Excel (without the use of any VBA or coding).

You can use this technique to fetch all the file names from a folder and list that in Excel.

This Excel trick uses an old Excel Function - FILES.

FILES function can be used to get the list of all the file names (or specific file names) in a specific folder in Excel. It an old excel function that does not work in the worksheet, but still works in named ranges in Excel.

All you need is this formula with the folder address.

To get the folder address, save the excel file in the same folder and use this formula - =SUBSTITUTE(CELL("filename"),RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("@",SUBSTITUTE(CELL("filename"),"\","@",LEN(CELL("filename"))-LEN(SUBSTITUTE(CELL("filename"),"\",""))),1)),"*")

One of the good things about this method is that it allows you to get specific files from the folder. For example, if you want to only get Excel files or only Word Files, or Only files with a specific extension, you can do that using this method.

Here is a step-by-step written tutorial (which also shows how to do this using VBA):
https://trumpexcel.com/list-of-file-n...




Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/

⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial