Cindi, try this, file must be saved first for it to work

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"cindi" wrote in message
...
Can I create a formula in a cell that will equal the
sheet tab name?

Thanks,

Cindi