Worksheet Name
 

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.

Worksheet Name
 

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

Your file must be saved for this to work.

HTH,
Paul

"Bob" wrote in message
...
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.

Worksheet Name
 

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)



"Bob" wrote in message
...
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.

Worksheet Name
 

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

"PCLIVE" wrote:


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

Your file must be saved for this to work.

HTH,
Paul

"Bob" wrote in message
...
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.