worksheet label in a cell

  • Thread starter Thread starter Gecko
  • Start date Start date
G

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 !
 
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"
<><><><><><><><><><>
 
Another one.. a bit shorter

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

If this post helps click Yes
 
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 said:
Another one.. a bit shorter

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

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


Gecko said:
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 !
Click to expand...
Click to expand...
 
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 said:
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 said:
Another one.. a bit shorter

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

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


Gecko said:
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 !
Click to expand...
Click to expand...
Click to expand...
 
Back
Top