Worksheet (tab names) in cells

[Guest]

Using a formula, is there a way to display worksheet (tab names) in a cell?
For example, I have 3 worksheets with names One, Two and Three. In cell A1 in
each woksheet, I would want to see the worksheet name for whichever worksheet
I am viewing. I do not want the name to change in the cell each time I click
on one of the other two spreadsheets, similar to what happens with
=CELL("FILENAME"). I also do not want to see the entire path for the
worksheet.

 

[smw226 via OfficeKB.com]

Hi,

=MID(CELL("filename"),(FIND("]",CELL("filename")))+1,50)

Thanks,

Simon

 

[Zack Barresse]

Hi there,

If you use the CELL() function, don't forget to set the reference (second
syntax). This is a *very* important part of the function. Just link it to
any cell in the current sheet you're wishing to return (the name of). If
working with multiple worksheets/workbooks, you'll save yourself a lot of
headaches down the road.

HTH

 

[Paul B]

wdogolf, try this,
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003