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 stepbystep written tutorial (which also shows how to do this using VBA):
https://trumpexcel.com/listoffilen...
Free Excel Course https://trumpexcel.com/learnexcel/
Paid Online Training https://trumpexcel.com/exceltraining/
Best Excel Books: https://trumpexcel.com/bestexcelbooks/
⚙ 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