Display tab name only in a cell

[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.

 

[Max]

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

 

[TKT-Tang]

Mr. Nigel,

Try, enter into Cell A11 :

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

Regards.