Forum Discussion
Cell formula
Looking for formula to put filename of spreadsheet into cell so that it is updated. (this way can be shown in printed doc for reference)
You can easily place the filename in the header or footer.
If you prefer a cell formula:
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)
Now I would use
= TEXTBEFORE( TEXTAFTER(CELL("filename"),"["), "]" )My 365 blinkers are firmly in place!
