What function returns the sheet name?

[bao...@my-deja.com]

Oh sher, I know I can always parse CELL("filename"), which returns a
Webster's Collegiate Edition-length string whose last segment is the
sheet name. But, I mean, aghhh!

Doofus user full disclosure dept.: I'm, uh, <gulp>, heh heh, still
running Excel 97 SR2.

Thanks.

***

[JW]

The below formula will work, as long as the workbook you are placing
it in is saved. If it's not, you will receive an error because there
isn't a filename associated with it until it is saved.
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))
+1,LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))