» 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:
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- The 11 Immutable Laws of Internet Branding
- Wall Street Journal Guide to Understanding Money and Investing
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- The One Page Business Plan: Start With a Vision, Build a Company!
No comments have been submitted.
