Worksheet Name

[Guest]

What is the formula to display just the worksheet name in cell? For instance
the worksheet name is January 2007 and I would like January 2007 displayed in
several areas within this worksheet. I am using Excel 2003.

 

[PCLIVE]

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

Your file must be saved for this to work.

HTH,
Paul

 

[Bob Phillips]

See http://xldynamic.com/source/xld.xlFAQ0002.html

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Perfect....Thanks for the quick reply!!!

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

Your file must be saved for this to work.

HTH,
Paul

What is the formula to display just the worksheet name in cell? For
instance
the worksheet name is January 2007 and I would like January 2007 displayed
in
several areas within this worksheet. I am using Excel 2003.