Couple of quibbles:
1) You should use the reference argument to CELL() (e.g.,
CELL("fileneame", A1)) or it will return the name of the sheet in which
the last cell was changed/calculated. This may be a different sheet than
the one that the formula resides in.
2) Worksheet names can be 31 characters long. Using 30 in your MID
formula could truncate the worksheet name. I use 255 (2^8 - 1) just to
indicate a big number).
In article ,
"Jack Sons" wrote:
Excel can do what you want. Put in any cell:
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,30)
|