Tip Printed from ExcelTip.com
How to extract a file name from a path in Microsoft Excel



Path & File name:       c:\My Documents\ExcelTip.xls
 
The Function:            

=MID(A25,FIND("*",SUBSTITUTE(A25,"\","*",LEN(A25)-LEN(SUBSTITUTE(A25,"\",""))))+1,LEN(A25))

Result:                 ExcelTip.xls