You can reference a cell using INDIRECT but not the greater than sign..

A1 = '=A6'
=INDIRECT(MID(A1,2,LEN(A1))) 0

If this post helps click Yes
---------------
Jacob Skaria


"JCC" wrote:

Your answer is correct, but I didn't ask the right question. I simplified my
question too much. If I have a formula as text in A1 (i.e. "=AL60") how do
I see the result of that formula by referencing A1?

"Jacob Skaria" wrote:

Cell A1 content is "=B2".
--If you mean =B2 as text try the below formula

=INDIRECT(MID(A1,2,LEN(A1)))

--If you mean formula =B2
=A1


If this post helps click Yes
---------------
Jacob Skaria


"JCC" wrote:

Cell A1 content is "=B2". I want to reference A1 and get the contents of B2.