ExcelTip.com
ExcelTip.com
Account Icon Account Icon Account Icon
Google Exceltip.com
JOIN OUR NEWSLETTER
  and receive for joining:
Free eBook Learn More!
Free Excel ADD-IN
Free Weekly Excel Tip
4 e-books in cd-rom
F1 Formulas & Functions
F1 Formulas & Functions
F1 EXCEL
F1 eBook (Spanish)
F1 EXCEL
Financial Statements.xls
 

» 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
Rate this tip
12 34 5
  RATING: 3.09
  VIEWS: 33942

READER COMMENTS (view all comments)


No comments have been submitted.


REGISTERED USERS - Click here to post comments


GUESTS (Click here to register)
Name
Comment Title
Comments

The Fall of Advertising and the Rise of PR

Windows XP for Dummies

Microsoft Word Version 2002 Inside Out

Financial Modeling - 2nd Edition

Special Edition Using Microsoft Outlook 2002

Special Edition Using Microsoft Office XP

RELATED MICROSOFT EXCEL TIPS


Convert PDF Files to Excel


Excel VBA books
Accounting books
Business Plans
MS Office books
Taxes books

VIEW ALL BOOKS