Watch Video – Get List of File Names from a Folder in Excel So ROW()-2 would be 1 for the first instance, 2 for the second instance when the row number is 4, and so on and so forth. Note that I have used ROW()-2, as we started from the third row onwards. In the INDEX formula, we have given the file names as the array and we return the 1st, 2nd, 3rd file names and so on using the ROW function. Similarly, for word document files, use *doc*įILES formula retrieves the names of all the files of the specified extension in the specified folder. So the folder address that you need to use would be C:\Users\Sumit\Desktop\Test Folder\*xls* For example, if you want only excel files, you can use *xls* instead of * If you want to get all the files with a particular extension, just change the asterisk with that file extension. Want to Extract Files with a Specific Extension?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |