Text in cell as Formula
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.
|