D
Dr. Darrell
Is there a function that links the text on the Worksheet Tab to a Cell?
Darrell
Darrell
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.
... I would like the Worksheet Tab Title to be in Cell A1 too...
P
Peo Sjoblom
One way
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
D
Dr. Darrell
Peo:
This seems to be a method to extract text from a string in a given cell. I
don't think it will work with the TAB. (unless the Tab has an address similar
to a cell's address.
This seems to be a method to extract text from a string in a given cell. I
don't think it will work with the TAB. (unless the Tab has an address similar
to a cell's address.
Peo Sjoblom said:One way
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
--
Regards,
Peo Sjoblom
Dr. Darrell said:Is there a function that links the text on the Worksheet Tab to a Cell?
Darrell
P
Peo Sjoblom
Why don't you try it
--
Regards,
Peo Sjoblom
--
Regards,
Peo Sjoblom
Dr. Darrell said:Peo:
This seems to be a method to extract text from a string in a given cell. I
don't think it will work with the TAB. (unless the Tab has an address similar
to a cell's address.
Peo Sjoblom said:One way
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
--
Regards,
Peo Sjoblom
Dr. Darrell said:Is there a function that links the text on the Worksheet Tab to a Cell?
Darrell
D
Dr. Darrell
I entered my file name: =MID(CELL(Test,A1),FIND("]",CELL(Test,A1))+1,32)
I entered my file name along with it's extension:
=MID(CELL(Test.xls,A1),FIND("]",CELL(Test.xls,A1))+1,32)
I entered my file name along with it's extension and it's path:
=MID(CELL('C':\Documents and Settings\Darrell.Roak.PUMP_EXCH\My
Documents\Test.xls,A1),FIND("]",CELL('C':\Documents and
Settings\Darrell.Roak.PUMP_EXCH\My Documents\Test.xls,A1))+1,32)
The result was the same: #NAME (formular result = volitile)
My worksheet Tab name is "Test Tab"
Am I supposed to substitute something for "]" ?
I entered my file name along with it's extension:
=MID(CELL(Test.xls,A1),FIND("]",CELL(Test.xls,A1))+1,32)
I entered my file name along with it's extension and it's path:
=MID(CELL('C':\Documents and Settings\Darrell.Roak.PUMP_EXCH\My
Documents\Test.xls,A1),FIND("]",CELL('C':\Documents and
Settings\Darrell.Roak.PUMP_EXCH\My Documents\Test.xls,A1))+1,32)
The result was the same: #NAME (formular result = volitile)
My worksheet Tab name is "Test Tab"
Am I supposed to substitute something for "]" ?
Peo Sjoblom said:Why don't you try it
--
Regards,
Peo Sjoblom
Dr. Darrell said:Peo:
This seems to be a method to extract text from a string in a given cell. I
don't think it will work with the TAB. (unless the Tab has an address similar
to a cell's address.
Peo Sjoblom said:One way
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
--
Regards,
Peo Sjoblom
Is there a function that links the text on the Worksheet Tab to a Cell?
Darrell
D
Dave Peterson
Don't make any changes with Peo's original formula. Just copy and paste
directly to the formula bar for that cell.
directly to the formula bar for that cell.
Dr. Darrell said:I entered my file name: =MID(CELL(Test,A1),FIND("]",CELL(Test,A1))+1,32)
I entered my file name along with it's extension:
=MID(CELL(Test.xls,A1),FIND("]",CELL(Test.xls,A1))+1,32)
I entered my file name along with it's extension and it's path:
=MID(CELL('C':\Documents and Settings\Darrell.Roak.PUMP_EXCH\My
Documents\Test.xls,A1),FIND("]",CELL('C':\Documents and
Settings\Darrell.Roak.PUMP_EXCH\My Documents\Test.xls,A1))+1,32)
The result was the same: #NAME (formular result = volitile)
My worksheet Tab name is "Test Tab"
Am I supposed to substitute something for "]" ?
Peo Sjoblom said:Why don't you try it
--
Regards,
Peo Sjoblom
Dr. Darrell said:Peo:
This seems to be a method to extract text from a string in a given cell. I
don't think it will work with the TAB. (unless the Tab has an address similar
to a cell's address.
:
One way
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
--
Regards,
Peo Sjoblom
Is there a function that links the text on the Worksheet Tab to a Cell?
Darrell
D
Dr. Darrell
I copied and pasted the formular as typed by Peo and I got the same result:
"#NAME"
Darrell
"#NAME"
Darrell
Dave Peterson said:Don't make any changes with Peo's original formula. Just copy and paste
directly to the formula bar for that cell.
Dr. Darrell said:I entered my file name: =MID(CELL(Test,A1),FIND("]",CELL(Test,A1))+1,32)
I entered my file name along with it's extension:
=MID(CELL(Test.xls,A1),FIND("]",CELL(Test.xls,A1))+1,32)
I entered my file name along with it's extension and it's path:
=MID(CELL('C':\Documents and Settings\Darrell.Roak.PUMP_EXCH\My
Documents\Test.xls,A1),FIND("]",CELL('C':\Documents and
Settings\Darrell.Roak.PUMP_EXCH\My Documents\Test.xls,A1))+1,32)
The result was the same: #NAME (formular result = volitile)
My worksheet Tab name is "Test Tab"
Am I supposed to substitute something for "]" ?
Peo Sjoblom said:Why don't you try it
--
Regards,
Peo Sjoblom
Peo:
This seems to be a method to extract text from a string in a given cell. I
don't think it will work with the TAB. (unless the Tab has an address
similar
to a cell's address.
:
One way
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
--
Regards,
Peo Sjoblom
Is there a function that links the text on the Worksheet Tab to a
Cell?
Darrell
D
Dave Peterson
Did you use Peo's original formula?
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
I bet you changed it slightly.
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
I bet you changed it slightly.
Dr. Darrell said:I copied and pasted the formular as typed by Peo and I got the same result:
"#NAME"
Darrell
Dave Peterson said:Don't make any changes with Peo's original formula. Just copy and paste
directly to the formula bar for that cell.
Dr. Darrell said:I entered my file name: =MID(CELL(Test,A1),FIND("]",CELL(Test,A1))+1,32)
I entered my file name along with it's extension:
=MID(CELL(Test.xls,A1),FIND("]",CELL(Test.xls,A1))+1,32)
I entered my file name along with it's extension and it's path:
=MID(CELL('C':\Documents and Settings\Darrell.Roak.PUMP_EXCH\My
Documents\Test.xls,A1),FIND("]",CELL('C':\Documents and
Settings\Darrell.Roak.PUMP_EXCH\My Documents\Test.xls,A1))+1,32)
The result was the same: #NAME (formular result = volitile)
My worksheet Tab name is "Test Tab"
Am I supposed to substitute something for "]" ?
:
Why don't you try it
--
Regards,
Peo Sjoblom
Peo:
This seems to be a method to extract text from a string in a given cell. I
don't think it will work with the TAB. (unless the Tab has an address
similar
to a cell's address.
:
One way
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
--
Regards,
Peo Sjoblom
Is there a function that links the text on the Worksheet Tab to a
Cell?
Darrell
D
David
=?Utf-8?B?RHIuIERhcnJlbGw=?= wrote
I seem to recall you have to save the file before the formula takes effect.
I copied and pasted the formular as typed by Peo and I got the same
result: "#NAME"
Darrell
I seem to recall you have to save the file before the formula takes effect.
D
Dave Peterson
But I get a #value! error if the workbook wasn't saved.
D
David
Dave Peterson wrote
I'll have to bow to your considerably greater experience in these matters.
I just didn't see any reference to saving the file in this thread.
But I get a #value! error if the workbook wasn't saved.
I'll have to bow to your considerably greater experience in these matters.
I just didn't see any reference to saving the file in this thread.
D
Dave Peterson
It wasn't greater experience--I just copied the formula into a new workbook and
saw the results <bg>.
saw the results <bg>.