Need a function to add the sheet name to a cell.

  • Thread starter Thread starter Terence Lyles
  • Start date Start date
T

Terence Lyles

I'm having a problem getting a function to add just the
sheet name to a cell. I looked on the support site and
found a function that adds gives me the whole path of the
saved file down to the sheet name, but I just need the
sheet name. Any help would welcome. The function I found
is below.

=RIGHT(CELL("filename"),LEN(CELL("filename"))-
MAX(IF(NOT(ISERR(SEARCH("\",CELL("filename"),
ROW(1:255)))),SEARCH("\",CELL("filename"),ROW
(1:255)))))
 
Terence,

RIGHT(CELL("FILENAME",A1),LEN(CELL("FILENAME",A1))-FIND("]",CELL("FILENAME",
A1)))

Works in XL2000 for me.


PC
 
Back
Top