It sounds like you want to do an indirect.
Let's say that cell D1 contains the text "A1" which could change to another
cell reference. But maybe you still want to reference worksheet1.

=INDIRECT("worksheet1!" & D1)

if you had "worksheet1!A1" in cell D1, then:
=INDIRECT(D1)

Does that help?
Paul





--

"tjc" wrote in message
...
How can I show a cell reference as a text? For example, if cell A1
contains
the formula =worksheet1!A1, it will return the contents of the cell
referenced. In a different cell, I'd like to show the text
"=worksheet1!A1".
More specifically, I'd like to be able to extract the text "worksheet1"
from
the original formula.