Something like this may work for you.

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

Regards,
Paul


"John S" <John wrote in message
...
I am trying to figure out a formula that will result in the name of the
sheet
that formula is in. Similar to a =Info(type_text) but that will simply
output
the name of the sheet.

any help?