Thanks JE, I didn't think of it.

Jack.

"JE McGimpsey" schreef in bericht
...
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)