| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Worksheet Functions | |||
| Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
Hybrid Mode
