![Excel: how to return a filename without extension to cell formula | Excel, Work skills, Excel spreadsheets Excel: how to return a filename without extension to cell formula | Excel, Work skills, Excel spreadsheets](https://i.pinimg.com/1200x/7d/7a/6d/7d7a6ddc9c042ef738e932ca35aca231.jpg)
Excel: how to return a filename without extension to cell formula | Excel, Work skills, Excel spreadsheets
![Tom's Tutorials For Excel: Using a Formula to Get Your Active Worksheet's Name, and Active Workbook's Path and Name – Tom Urtis Tom's Tutorials For Excel: Using a Formula to Get Your Active Worksheet's Name, and Active Workbook's Path and Name – Tom Urtis](http://www.atlaspm.com/wp-content/uploads/2013/05/Formula_WorkbookPathName.png)
Tom's Tutorials For Excel: Using a Formula to Get Your Active Worksheet's Name, and Active Workbook's Path and Name – Tom Urtis
CELL ("filename") returns the path, filename, and work sheet name of the workbook and worksheet : Cell « Information functions « Microsoft Office Excel 2007 Tutorial
![worksheet function - =CELL("filename") doesn't work with multiple Excel files open at the same time - Super User worksheet function - =CELL("filename") doesn't work with multiple Excel files open at the same time - Super User](https://i.stack.imgur.com/nsbTl.png)