Have a cell in Excel return a string that contains the name of the worksheet the cell is in.?

Question

Say I have a regular old Excel workbook with 3 sheets I've named "North View", "South View", and "East View." I want $A$1 to display the name of the sheet it's in. How can I get some string of data that includes the sheet name? Then I could parse out the unnecessary parts of the string with Search() and such.

I've done it before a couple of years ago; I'm just a little too dim to remember it now.

Answer 1

Hmmm is this what you're trying to do?

=MID(CELL("filename",A1),FIND("]",CELL...

EDIT: It's cutting the formula off during preview for me so  I'll post it in piieces for you in case it's cutting it off for you, but it's actually one line, no spaces:

=MID(CELL("filename",A1),

FIND("]",CELL("filename",A1

))+1,256)