software

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(quot;filenamequot;,A1),FIND(quot;]quot;,CELL(quot;filenamequot;,A1)) 1,32)
(workbook must be saved first)
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;john andersonquot; lt;john gt; wrote in message
...
gt; I need a formula to show the tab name only in the spreadsheet. I know how
to
gt; get the file and path name, but that brings up too much information. I
only
gt; want it to display the tab name.
=MID(CELL(quot;filenamequot;,A1),FIND(quot;]quot;,CELL(quot;filenamequot;,A1)) 1,255)

It's not my intention, I found it int this forum, but Iforgot the author's
name, sorry!

Regards,
Stefi?ohn anderson??ezt ?rta:

gt; I need a formula to show the tab name only in the spreadsheet. I know how to
gt; get the file and path name, but that brings up too much information. I only
gt; want it to display the tab name.

Another alternative (Technique from a post by Harlan)
is to create a defined name say, quot;WSNquot; as per steps below,
then we could just use quot;WSNquot; to refer to the sheetname
in formulas within the book

Click Insert gt; Name gt; Define
Put under quot;Names in workbook:quot;: WSN
Put in the quot;Refers to:quot; box:
=MID(CELL(quot;Filenamequot;,INDIRECT(quot;A1quot;)),FIND(quot;]quot;,CELL(quot;Filenamequot;,INDIRECT(quot;A1quot;)
)) 1,32)
Click OK

[As before, the workbook must be saved first]
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
gt; .. then we could just use quot;WSNquot; to refer to the sheetname
gt; 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
savefile.com/projects/236895
xdemechanik
---