60 Things That Excel Can Do

Feature 45 - Get the file name from the full path name

The following assumes a full path name is in cell A2 for example:

A2: C:\Laptop_backup\Flash Drive grey\Save\50 per day.xls

B2: =RIGHT(A2,LEN(A2)-FIND("@",SUBSTITUTE(A2,"\","@",LEN(A2)-LEN(SUBSTITUTE(A2,"\",""))),1))

The following VBA code will also get the file name



Function GetFileName(s)

for i = len(s) to 1 step -1

    if mid(s,i,1) = "/" then

       Getfilename = mid(s,i)

       exit for

    end if

next

end function