File System - FileNames

Syntax:
=FileNames(Directory)

Array function.
To use this function select a range of cells (e.g. 1 column and 10 rows). Type the function and press Ctrl+Shift+Enter

Description:
Returns the names of the files in the directory.

Directory: Name of the directory containing the files

Example: