G Guest May 4, 2004 #1 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
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 May 4, 2004 #2 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?
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 May 4, 2004 #3 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?
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?
