Try this:

=MID(CELL("FILENAME",A1),FIND("]",CELL("FILENAME",A1))+1,999)

Note, that the workbook must be saved in order for this to work.

HTH,
Elkar


"JayJay" wrote:

I want a function like =INFO() or =CELL() that returns the name of the
current worksheet, e.g. =CELL("WorkSheetName"). Is there such a function?