![]() 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 |