https://trumpexcel.com/wp-content/uploads/2017/12/Get-File-names-from-folder-from-folder.png

1 minute read Let’s image that the following path is in A1: C:UsersfooDocumentsparent.folderfoo.bar.txt To get the file, parent folder and path names use the following formulas which all point to A1. File Names File Name with File Type Result: foo.bar.txt =MID(A1,FIND(“*”,SUBSTITUTE(A1,””,*”””””