Use the following formula:

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

The file must have been saved to disk for this to work.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"donaldD" wrote in message
...
Excel - I would like to refer to the sheet tab name on the
spreadsheet...I
know you can use the simple (tab) command in the header, but
what would be
the "formula" you would put in a cell to refer to the sheet tab
name...ie
={tab}?