Home » Science & Technology » List of filenames from folder into Excel

List of filenames from folder into Excel

Written By Karina Adcock on Wednesday, Dec 16, 2020 | 09:00 AM

 
Copy Folder Path into excel. Add "\*" onto end of folder path. Make a named range using the formula =FILES() and then use the named range to get a list of file names. --------------------------------------------------------------------------------- #exceltips #exceltutorials SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office 365, 2016, Office Insider, Version 2012 --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - Copy list of filenames from folder into Excel (Windows) https://youtu.be/F7SE5h7AUBg - List of filenames from folder and subfolders into Excel https://youtu.be/NQ3uOFpDRXM - List of filenames from folder into Excel (Windows) https://youtu.be/771XysaD1DU