View Single Post
  #1   Report Post  
SU
 
Posts: n/a
Default 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.