![]() 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? Drag this down and it will give you a list of all the file names in the folder.= IFERROR(INDEX(FileNameList, ROW()-2),"") Go to cell A3 (or any cell where you want the list of names to start) and enter the following formula: Now to get the list of files, we will use the named range within an INDEX function.Name: FileNameList (feel free to choose whatever name you like).In the New Name dialogue box, use the following details.Go to the ‘Formulas’ tab and click on the ‘Define Name’ option.Now you can copy-paste ( paste as value) this address in any cell (A1 in this example) in the workbook in which you want the file names. This formula will give you the folder address and adds an asterisks sign (*) at the end. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |