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.

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.

=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.

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
---

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