If you want to find out what an Excel function does, put the function name
into Excel's help. It will tell you the syntax, show examples, and often
cross-refer to related functions too.
--
David Biddulph

"Al" wrote in message
...
These both work...many thanks to you. I'm now reading up on MID and FIND
functions, but could you please explain what your functions are actually
doing. Thanks in advance!

"Bernard Liengme" wrote:

This will work only if the file has been saved
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
best wishes

"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