Question: how to put file names into excel?
Answer: Select cell A1. Go to Formula tab in the ribbon. Select Define Name from the Defined Names section. Type in List_Of_Names in the Name area. Type in =FILES(Sheet1!$ A$1) in the Refers to area. Press the OK button.