Sheet name as cell value

J

Jon

Is there a formula, or "dynamic" method of taking the sheet name an
putting it as a value in the same sheet.

If the sheet name changes, the cell then updates with the new name.

?
 
A

Arvi Laanemets

Hi

=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,36)


Arvi Laanemets
 
Top