Formula To Get File And Folder Names

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,"",*"""""

Leave a Comment