This formula will give you spurious results.

=RIGHT(CELL("filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename")))

See Bob Phillips' site for explanation.

http://www.xldynamic.com/source/xld.xlFAQ0002.html


Gord Dibben MS Excel MVP

On Sun, 8 Jun 2008 08:56:05 -0400, "bpauley" wrote:

Gentlemen,
Thank you so much for the quick and efficient assistance. Both formulas
worked well, however, Ron's permitted for changes in the tab name to be
displayed in the cell in the worksheet immediately. Don't know why but it
did. So, that is the formula I am using.
Again thank you both for the assistance.
Bill

"Ron Coderre" wrote in message
...
Try this:

A1: =MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,255)

Does that help?
Post back if you have more questions.

Regards,

Ron
Microsoft MVP - Excel

"bpauley" wrote in message
...
Excel 2000, Vista
How do you refer to the info on the tab (worksheet name) in a cell in the
worksheet
Thank you,
Bill