show sheet tab label in a cell on the sheet?

[merlin777]

is it possible to display the name of a sheet in a cell on that sheet?

 

[Fluff]

How about
=TRIM(RIGHT(SUBSTITUTE(CELL("filename"),"]",REPT(" ",100)),100))
or
=MID(CELL("filename"),SEARCH("]",CELL("filename"))+1,100)

 

[merlin777]

perfect - thanks, fluff

 

[Fluff]

You're welcome & thanks for the feedback

 

[merlin777]

something not quite right. I'm using this on 12 sheets (jan to dec) in cell A1 on each sheet. When i copy and paste your formula into each sheet, although it shows that sheet's name in A1 it also shows the same thing in the other 11 sheets? e.g. i paste it into A1 on the june sheet and all the sheets jan to dec now also show june in their A1 cell.

 

[Fluff]

Missed the cell Ref, which ever formula your using, change
CELL("filename")
to
CELL("filename",A1)

 

[merlin777]

Missed the cell Ref, which ever formula your using, change
CELL("filename")
to
CELL("filename",A1)

cheers

 

[Fluff]

You're welcome