D
daniel chen
Will someone please help me with a formula.
Lets say I want cell G8 to reflect the sheetname it is in.
Thanks,
Lets say I want cell G8 to reflect the sheetname it is in.
Thanks,
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Arvi Laanemets
Hi
=MID(CELL("filename",$A$1),FIND("[",CELL("filename",$A$1))+1;FIND("]",CELL("
filename",$A$1))-FIND("[",CELL("filename",$A$1))-1)
returns workbooks name
=MID(CELL("filename";$A$1);FIND("]";CELL("filename";$A$1))+1;99)
returns worksheets name
Arvi Laanemets
=MID(CELL("filename",$A$1),FIND("[",CELL("filename",$A$1))+1;FIND("]",CELL("
filename",$A$1))-FIND("[",CELL("filename",$A$1))-1)
returns workbooks name
=MID(CELL("filename";$A$1);FIND("]";CELL("filename";$A$1))+1;99)
returns worksheets name
Arvi Laanemets
B
Bob Phillips
Take a look at http://www.xldynamic.com/source/xld.xlFAQ0002.html
--
HTH
RP
(remove nothere from the email address if mailing direct)
--
HTH
RP
(remove nothere from the email address if mailing direct)
D
daniel chen
Thank you very much, Arvi
I think it's typo-error
I have to replace all the ";" with ","
I think it's typo-error
I have to replace all the ";" with ","
Arvi Laanemets said:Hi
=MID(CELL("filename",$A$1),FIND("[",CELL("filename",$A$1))+1;FIND("]",CELL("
filename",$A$1))-FIND("[",CELL("filename",$A$1))-1)
returns workbooks name
=MID(CELL("filename";$A$1);FIND("]";CELL("filename";$A$1))+1;99)
returns worksheets name
Arvi Laanemets
daniel chen said:Will someone please help me with a formula.
Lets say I want cell G8 to reflect the sheetname it is in.
Thanks,
B
Bob Phillips
Daniel,
It is not a typo to Arvi. In Europe, Excel uses semi-colon as the separator
in functions, whereas most of the rest of the world (including the UK) uses
comma.
--
HTH
RP
(remove nothere from the email address if mailing direct)
It is not a typo to Arvi. In Europe, Excel uses semi-colon as the separator
in functions, whereas most of the rest of the world (including the UK) uses
comma.
--
HTH
RP
(remove nothere from the email address if mailing direct)
daniel chen said:Thank you very much, Arvi
I think it's typo-error
I have to replace all the ";" with ","
Arvi Laanemets said:Hi
=MID(CELL("filename",$A$1),FIND("[",CELL("filename",$A$1))+1;FIND("]",CELL("
filename",$A$1))-FIND("[",CELL("filename",$A$1))-1)
returns workbooks name
=MID(CELL("filename";$A$1);FIND("]";CELL("filename";$A$1))+1;99)
returns worksheets name
Arvi Laanemets
daniel chen said:Will someone please help me with a formula.
Lets say I want cell G8 to reflect the sheetname it is in.
Thanks,
D
daniel chen
Good to know, Bob
Bob Phillips said:Daniel,
It is not a typo to Arvi. In Europe, Excel uses semi-colon as the
separator
in functions, whereas most of the rest of the world (including the UK)
uses
comma.
--
HTH
RP
(remove nothere from the email address if mailing direct)
daniel chen said:Thank you very much, Arvi
I think it's typo-error
I have to replace all the ";" with ","
Arvi Laanemets said:Hi
=MID(CELL("filename",$A$1),FIND("[",CELL("filename",$A$1))+1;FIND("]",CELL("
filename",$A$1))-FIND("[",CELL("filename",$A$1))-1)
returns workbooks name
=MID(CELL("filename";$A$1);FIND("]";CELL("filename";$A$1))+1;99)
returns worksheets name
Arvi Laanemets
Will someone please help me with a formula.
Lets say I want cell G8 to reflect the sheetname it is in.
Thanks,
A
Arvi Laanemets
Hi
Sorry, but I forgot to replace them in second formula myself!
Arvi Laanemets
Sorry, but I forgot to replace them in second formula myself!
Arvi Laanemets
daniel chen said:Thank you very much, Arvi
I think it's typo-error
I have to replace all the ";" with ","
Arvi Laanemets said:Hi
=MID(CELL("filename",$A$1),FIND("[",CELL("filename",$A$1))+1;FIND("]",CELL("
filename",$A$1))-FIND("[",CELL("filename",$A$1))-1)
returns workbooks name
=MID(CELL("filename";$A$1);FIND("]";CELL("filename";$A$1))+1;99)
returns worksheets name
Arvi Laanemets
daniel chen said:Will someone please help me with a formula.
Lets say I want cell G8 to reflect the sheetname it is in.
Thanks,