=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))
--
David Biddulph

"Al" wrote in message
...
Any way to import a tab name into a cell such that the cell text is the
same
as the tab?

(Tab name = Project ABC, and I'd like to automatically set cell B2 to
"Project ABC")

Allan