| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tab name in specific cell
Can I have the tab name show in a specific cell, whereas when the tab name is
changed, the cell reults also change ? And if so, is it simply a formula? Thanks, Steve |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Tab name in specific cell
Try this:
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) Does that help? *********** Regards, Ron XL2002, WinXP "Steve" wrote: Can I have the tab name show in a specific cell, whereas when the tab name is changed, the cell reults also change ? And if so, is it simply a formula? Thanks, Steve |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Tab name in specific cell
I'm getting a #Value!
=MID(CELL("Master"),FIND(")",CELL("Master"))+1,255 ) "Ron Coderre" wrote: Try this: =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) Does that help? *********** Regards, Ron XL2002, WinXP "Steve" wrote: Can I have the tab name show in a specific cell, whereas when the tab name is changed, the cell reults also change ? And if so, is it simply a formula? Thanks, Steve |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Tab name in specific cell
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) "Ron Coderre" wrote in message ... Try this: =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) Does that help? *********** Regards, Ron XL2002, WinXP "Steve" wrote: Can I have the tab name show in a specific cell, whereas when the tab name is changed, the cell reults also change ? And if so, is it simply a formula? Thanks, Steve |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Tab name in specific cell
Steve....
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) You can just copy the formula directly from the post and paste it into the formula bar. "filename" is not the name of your file. It's the Info_Type to be returned by the CELL function. (I should have been more clear.) Does that help? *********** Regards, Ron XL2002, WinXP "Steve" wrote: I'm getting a #Value! =MID(CELL("Master"),FIND(")",CELL("Master"))+1,255 ) "Ron Coderre" wrote: Try this: =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) Does that help? *********** Regards, Ron XL2002, WinXP "Steve" wrote: Can I have the tab name show in a specific cell, whereas when the tab name is changed, the cell reults also change ? And if so, is it simply a formula? Thanks, Steve |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Tab name in specific cell
If you put my posted formula in more than one sheet.....
all formulas will return the same value on all sheets (unless you recalculate) To force them to show the correct sheet names, try this, instead =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)&T(NOW()) *********** Regards, Ron XL2002, WinXP "Ron Coderre" wrote: Steve.... =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) You can just copy the formula directly from the post and paste it into the formula bar. "filename" is not the name of your file. It's the Info_Type to be returned by the CELL function. (I should have been more clear.) Does that help? *********** Regards, Ron XL2002, WinXP "Steve" wrote: I'm getting a #Value! =MID(CELL("Master"),FIND(")",CELL("Master"))+1,255 ) "Ron Coderre" wrote: Try this: =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) Does that help? *********** Regards, Ron XL2002, WinXP "Steve" wrote: Can I have the tab name show in a specific cell, whereas when the tab name is changed, the cell reults also change ? And if so, is it simply a formula? Thanks, Steve |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Tab name in specific cell
Ok, great. Thanks. I thought filename was the name of the file. Also, before
I saw this recalc post, I found some help here at work, and this formula also works =MID(CELL("filename",A4),FIND("]",CELL("filename",A4))+1,LEN(CELL("filename",A 4))-FIND("]",CELL("filename",A4))) Thanks again, Steve "Ron Coderre" wrote: If you put my posted formula in more than one sheet..... all formulas will return the same value on all sheets (unless you recalculate) To force them to show the correct sheet names, try this, instead =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)&T(NOW()) *********** Regards, Ron XL2002, WinXP "Ron Coderre" wrote: Steve.... =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) You can just copy the formula directly from the post and paste it into the formula bar. "filename" is not the name of your file. It's the Info_Type to be returned by the CELL function. (I should have been more clear.) Does that help? *********** Regards, Ron XL2002, WinXP "Steve" wrote: I'm getting a #Value! =MID(CELL("Master"),FIND(")",CELL("Master"))+1,255 ) "Ron Coderre" wrote: Try this: =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) Does that help? *********** Regards, Ron XL2002, WinXP "Steve" wrote: Can I have the tab name show in a specific cell, whereas when the tab name is changed, the cell reults also change ? And if so, is it simply a formula? Thanks, Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link from a specific Cell in Excel to a specific para. in Word | Excel Worksheet Functions | |||
| Lock data in a cell a specific cell based on selection on other ce | Excel Worksheet Functions | |||
| how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) | |||
| Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions | |||
| How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
Linear Mode
