Try this:

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

Note: the file must already exist. In other words, it must have already been
saved with a filename.

Biff

"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?