Hi Al

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


The file must be saved first.



--
Regards
Roger Govier



"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