The instructions below will show you step-by-step how to use it. The FILES function is based on an old Excel feature, which has to be applied in a special way. If you search through the list of Excel functions, FILES is not listed. But wait! Back away from the close button, there is another option.įor listing files in a folder we can also use a little-known feature from Excel version 4, which still works today, the FILES function. I could tell you to turn to VBA macros or PowerQuery, but then any non-VBA and non-PowerQuery users would close this post instantly. Listing the files in a folder is one of the activities which cannot be achieved using normal Excel formulas.
