Tab Name (Only) in a Cell

[Jerry]

How do you get the Tab name to be displayed in a cell on
the worksheet?

=cell("filename") works but it shows the entire filename
including (network)path...too much info.

 

[J.E. McGimpsey]

one way:

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

Note you need to include the A1 reference or the result will reply
to the last sheet calculated, not (necessarily) the sheet the
formula is on.