Sheetname formula
 

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?

Sheetname formula
 

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?

Sheetname formula
 

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?

Sheetname formula
 

=CELL("filename",A1)
--
Gary's Student


"John S" wrote:

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?