Sheetname in a cell

  • Thread starter Thread starter daniel chen
  • Start date Start date
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,
 
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
 
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,
Click to expand...
Click to expand...
 
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


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,
Click to expand...
Click to expand...
Click to expand...
 
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,
Click to expand...
Click to expand...
Click to expand...
 
Hi

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,
Click to expand...
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create VBA function (UDF) in Excel 2003 2
reference to an external file 6
Get sheet names 9
Cell value as part of a worksheet ref. in Excel 2
How do I make a cell = the sheet name? 6
Use a sheet name in a formula 7
Formatt of cell filled by formula 2
How do I use a worksheet name as an input variable to a formula? 6

Back
Top