» Cell Function Returns Sheet Name, Workbook Name and Path
CATEGORY - Excel Tools
VERSION - All Microsoft Excel Versions
The Cell function returns information about the formatting, location, or contents of the upper-left cell in a reference.To get the sheet name:
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
To get the workbook name:
=MID(CELL("filename"),FIND("[",CELL("filename"))+1,(FIND("]",CELL("filename"))+1)-FIND("[",CELL("filename"))-2)
To get the path address & workbook name:
=CELL("filename")
To get the path address:
=MID(CELL("filename"),1,FIND("[",CELL("filename"))-1)

Book Store:
Recommended Books:
- The 11 Immutable Laws of Internet Branding
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Microsoft Windows XP Inside Out
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- The Basics of Finance: Financial Tools for Non Financial Managers
- Definitive Guide to Excel VBA
No comments have been submitted.

