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