Cell formula

Copper Contributor

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)

 

2 Replies

@KellyLifeview 

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)

@Hans Vogelaar 

Now I would use

= TEXTBEFORE( 
      TEXTAFTER(CELL("filename"),"["),
      "]"
  )

My 365 blinkers are firmly in place!