Don't make any changes with Peo's original formula. Just copy and paste
directly to the formula bar for that cell.



Dr. Darrell wrote:

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" wrote:

Why don't you try it

--

Regards,

Peo Sjoblom

"Dr. Darrell" wrote in message
...
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" wrote:

One way

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)


--

Regards,

Peo Sjoblom

"Dr. Darrell" wrote in message
...
Is there a function that links the text on the Worksheet Tab to a
Cell?

Darrell







--

Dave Peterson