sheet name

D

Daryl

I'm looking for a formula that will produce the sheet name (only) within the sheet the formula resides. Could somone please help me
Thank You
Daryl
 
H

Harald Staff

Hi Daryl

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename"
,A1),1))

Note that it won't work until the file is saved (= has a file path and file
name)

HTH. Best wishes Harald

Daryl said:
I'm looking for a formula that will produce the sheet name (only) within
Click to expand...
the sheet the formula resides. Could somone please help me?
 
F

Frank Kabel

Hi
one way:
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND
("]",CELL("filename"
,A1),1))
-----Original Message-----
I'm looking for a formula that will produce the sheet
Click to expand...
name (only) within the sheet the formula resides. Could
somone please help me?
 
Top