Display tab name only in a cell

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

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
 
T

TKT-Tang

Mr. Nigel,

Try, enter into Cell A11 :

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

Regards.
 
Top