![]() ![]() Here are the steps that will give you the file names from this folder: ![]() Now, suppose you have a folder with the name – ‘ Test Folder‘ on the desktop, and you want to get a list of file names for all the files in this folder. ![]() While this formula does not work in the worksheet cells, it still works in named ranges. We will use this fact to get the list of file names from a specified folder. It is from the childhood days of Excel spreadsheets (a version 4 formula). Here is a way to get names of files from folders and sub-folders using Power Query Using FILES Function to Get a List of File Names from a Folder You will not get the names of the files in the sub-folders within the main folder. Limitations of the methods shown in this tutorial: With the techniques shown below, you will only be able to get the names of the files within the main folder. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |