» How to extract a file name from a path in Microsoft Excel
CATEGORY - Excel Text , Working with Formulas
VERSION - All Microsoft Excel Versions
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
Book Store:
Recommended Books:
- Learn MS Excel 2002 VBA/XML Programming
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Special Edition Using Microsoft Word 2002
- How to Pay Zero Taxes (Annual)
- The New Financial Order: Risk in the Twenty-First Century
- Getting to Yes: Negotiating Agreement Without Giving In
No comments have been submitted.
