Steve....


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

You can just copy the formula directly from the post and paste it into the
formula bar.

"filename" is not the name of your file.
It's the Info_Type to be returned by the CELL function.
(I should have been more clear.)

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

XL2002, WinXP


"Steve" wrote:

I'm getting a #Value!

=MID(CELL("Master"),FIND(")",CELL("Master"))+1,255 )

"Ron Coderre" wrote:

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