Hi,

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

Thanks,

Simon

wdogolf wrote:
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.

--
Message posted via http://www.officekb.com