Formula to display name of tab

[DLombard]

Is there a formula which I can enter in a cell so that the value of that cell is the name of the tab / worksheet?

Thanks.

 

[mgirvin]

Dear DLombard,

You can try this:

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

 

[DLombard]

Thanks very much.