You need to use the literal word "filename" in the formula, not
the actual file name

=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,100).



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


"DBCollier" wrote in
message
...
I opened a new Excel file and saved it as "Accounting" and then
entered the
following formula in cell A1:
=MID(CELL("Accounting",$A$1),FIND("]",CELL("Accounting",$A$1))+1,100).

The result I got in cell A1 was "#VALUE!". Did I not enter it
correctly?

Thank you

"Duke Carey" wrote:

Try

=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,100)


"DBCollier" wrote:

I am trying to figure out a way in Excel to reference the
name of the sheet
tab using a formula. For example, in a new Excel document,
the name of the
first sheet tab defaults as "Sheet 1". I am trying to write
a formula in cell
A1 that would reference and show "Sheet 1" so that if I
renamed "Sheet 1" as
"Accounting", cell A1 would now read "Accounting.

Thank you in advance for help anyone can provide,
David