Worksheet Reference

[jtscpa]

Is there a function in Excel to display the Worksheet Name in a cell?

 

[Teethless mama]

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

 

[Soundar]

Hi,

You can display the worksheet name in the cell using the below formula.

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

But before using this one, u need to save.

Regards,
Soundar.