Dec 05 2022 08:59 AM
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)
Dec 05 2022 11:03 AM
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)
Dec 05 2022 11:45 AM
Now I would use
= TEXTBEFORE(
TEXTAFTER(CELL("filename"),"["),
"]"
)
My 365 blinkers are firmly in place!