Insert FileName Into a Cell

September 22nd, 2004 | Categories: Formulas | Tags:

-->

A formula to insert the filename of the workbook in a cell:

=MID(CELL(“filename”,A1),FIND(“[",CELL("filename",A1))+1,FIND("]“,
CELL(“filename”,A1))-FIND(“[“,CELL(“filename”,A1))-1)

Note: Remove the line break from the formula in Excel.

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!