|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 8th, 2009, 04:26 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
worksheet label in a cell
Hi,
Is there any formula that puts the value of the worksheet label in a cell ? My header and footer are already full (and no way to clean 'm ...) Thanks ! 
|
|
#2
October 8th, 2009, 04:39 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
worksheet label in a cell
Hi Gecko
Yes there is, try the below formula where you need it =RIGHT(CELL("filename",A1),LEN(CELL("filename",A1) )-SEARCH("]",CELL("filename",A1))) If this helps please click "Yes" "Gecko" wrote: Hi, Is there any formula that puts the value of the worksheet label in a cell ? My header and footer are already full (and no way to clean 'm ...) Thanks !
|
|
#3
October 8th, 2009, 04:46 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
worksheet label in a cell
Another one.. a bit shorter
=REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"") If this post helps click Yes --------------- Jacob Skaria "Gecko" wrote: Hi, Is there any formula that puts the value of the worksheet label in a cell ? My header and footer are already full (and no way to clean 'm ...) Thanks !
|
|
#4
October 8th, 2009, 05:25 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
worksheet label in a cell
Hi both,
It's not working, I get a #VALUE! error. Is it clear that I would like to have the 'tab' value ? Rgds. "Jacob Skaria" wrote: Another one.. a bit shorter =REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"") If this post helps click Yes --------------- Jacob Skaria "Gecko" wrote: Hi, Is there any formula that puts the value of the worksheet label in a cell ? My header and footer are already full (and no way to clean 'm ...) Thanks !
|
|
#5
October 8th, 2009, 05:36 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
worksheet label in a cell
May be I should have mentioned this earlier..This will work only if the
workbook is saved. Try the below in a saved workbook.. If this post helps click Yes --------------- Jacob Skaria "Gecko" wrote: Hi both, It's not working, I get a #VALUE! error. Is it clear that I would like to have the 'tab' value ? Rgds. "Jacob Skaria" wrote: Another one.. a bit shorter =REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"") If this post helps click Yes --------------- Jacob Skaria "Gecko" wrote: Hi, Is there any formula that puts the value of the worksheet label in a cell ? My header and footer are already full (and no way to clean 'm ...) Thanks !
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
