Tab Name (Only) in a Cell

  • Thread starter Thread starter Jerry
  • Start date Start date
J

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.
 
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.
 
Back
Top