» 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:
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Dictionary of Finance and Investment Terms
- Windows XP Annoyances
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Advanced modelling in finance using Excel and VBA
No comments have been submitted.
