Formula to return Sheet Name of referenced cell.

[mbdowty]

Is there a formula that will return the Tab or Sheet name of the referenced cell? Something like =Sheet(Sheet 1'!B25) that returns the text "Sheet1".

Thanks in advance...

Mark

 

[Oaktree]

=REPLACE(CELL("filename",'Sheet 1'!B25),1,SEARCH("]",CELL("filename",'Sheet 1'!B25)),"")

 

[mbdowty]

Excellent,

thanks OakTree