Tab Names
I need a formula to show the tab name only in the spreadsheet. I know how to
get the file and path name, but that brings up too much information. I only want it to display the tab name. |
Tab Names
Try in any cell:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32) (workbook must be saved first) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "john anderson" <john wrote in message ... I need a formula to show the tab name only in the spreadsheet. I know how to get the file and path name, but that brings up too much information. I only want it to display the tab name. |
Tab Names
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
It's not my intention, I found it int this forum, but Iforgot the author's name, sorry! Regards, Stefi €˛john anderson€¯ ezt Ć*rta: I need a formula to show the tab name only in the spreadsheet. I know how to get the file and path name, but that brings up too much information. I only want it to display the tab name. |
Tab Names
Another alternative (Technique from a post by Harlan)
is to create a defined name say, "WSN" as per steps below, then we could just use "WSN" to refer to the sheetname in formulas within the book Click Insert Name Define Put under "Names in workbook:": WSN Put in the "Refers to:" box: =MID(CELL("Filename",INDIRECT("A1")),FIND("]",CELL("Filename",INDIRECT("A1") ))+1,32) Click OK [As before, the workbook must be saved first] -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Tab Names
.. then we could just use "WSN" to refer to the sheetname
in formulas within the book .. Example: In any sheet, putting in any cell within the sheet: =WSN will return that sheet's tab name into the cell Or, applied within a formula: =VLOOKUP(WSN, ...) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
All times are GMT +1. The time now is 10:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com