worksheet label in a cell

[Gecko]

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 !

 

[BSc Chem Eng Rick]

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"
<><><><><><><><><><>

 

[Jacob Skaria]

Another one.. a bit shorter

=REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"")

If this post helps click Yes

 

[Gecko]

Hi both,

It's not working, I get a #VALUE! error.

Is it clear that I would like to have the 'tab' value ?

Rgds.

Another one.. a bit shorter

=REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"")

If this post helps click Yes
---------------
Jacob Skaria

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 !

 

[Jacob Skaria]

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

Hi both,

It's not working, I get a #VALUE! error.

Is it clear that I would like to have the 'tab' value ?

Rgds.

Another one.. a bit shorter

=REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"")

If this post helps click Yes
---------------
Jacob Skaria

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 !