Try this:

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

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Steve" wrote:

Can I have the tab name show in a specific cell, whereas when the tab name is
changed, the cell reults also change ? And if so, is it simply a formula?

Thanks,

Steve