Hi

=INDIRECT(B1)

Cheers
JulieD

"SU" wrote in message
...
Would it be possible to use text written in a cell to be used in a
formula?

For instance, say I have the value "10" wirtten in Cell A1
and I write text "A1" in cell A2
How do I incotporate this value in cell A2 to show 10 in cell A3?

I tried CONCATENATE but with no result.

Many thanks in advance for your help.