Careful - using

CELL("filename")

will return the value of the last sheet *calculated*, even if it's not
the sheet that the formula is entered in.

Instead, use the complete syntax, which provides a reference to a cell
in the sheet, e.g.,:

CELL("filename",A1)

The formula below can be written with fewer function calls:

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

where 255 is just a big number (anything over 30 will do...)

For more options, see

http://mcgimpsey.com/excel/formulae/cell_function.html

In article ,
John Bundy (remove) wrote:

After saving the workbook

=RIGHT(CELL("filename"),(LEN(CELL("filename"))-FIND("]",CELL("filename"))))