Display tab name only in a cell

  • Thread starter Thread starter nigel p
  • Start date Start date
N

nigel p

I wish to have only the tab name appear in a cell and have
unsuccessfully tried the ADDRESS function. I think this is probably a
simple question but Excel Help cannot. Can you help please?

Thank you in anticipation.
 
From a previous post by MVP Peo Sjoblom ..

Try: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)

Note: Workbook has to be saved first
 
Mr. Nigel,

Try, enter into Cell A11 :

=MID(CELL("Filename",A11),SEARCH("]",CELL("Filename",A11))+1,LEN(CELL("Filename",A11)))

Regards.
 
Back
Top