This will work only if the file has been saved
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"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