formula to reference sheet name

[ExcelAlice]

what is the formula to get the sheet name into a cell, much like

cell("filename", t1) would get the filename into a cell

 

[Jonmo1]

Try

=REPLACE(CELL("filename",A1),1,FIND("]",CELL("filename",A1)),"")

 

[Smitty]

Welcome to the Board!

Here's one way:

=REPLACE(CELL("filename", A1 ),1,FIND("]",CELL("filename", A1 )),"")

HTH,