File Name Function

[jmpalmer49]

Is there a way to use a function key to include the file name in a given cell in a spreadsheet? I am constantly wasting time because I can't remember the file name of the sheet when trying to find it in my documents.

 

[barry houdini]

You can get the filename of your current file with this formula in any cell

=REPLACE(LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1))-1),1,FIND("[",CELL("filename",A1)),"")

 

[jmpalmer49]

Thanks Barry! Works well.
Mike Palmer