![]() ![]() If you want to start the list in row 1, you can modify the formula as below: =IFERROR(INDEX(EXTRACTFILENAMES("C:\Excel Tutorials"),ROW()),"") Explanation of the Formula Note: In case you do not want to enter the path of the folder in a cell, you can hard-code the path into the formula as shown below: =IFERROR(INDEX(EXTRACTFILENAMES("C:\Excel Tutorials"),ROW()-3),"") In this case, we enter the full path in cell A1: Select any cell and enter the full path of the folder from which we want to extract the file names.Use the following steps to put the function into action: How to Use the User-Defined Function in the Workbook ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |