Text in cell as Formula

S

SU

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.
 
J

JulieD

Hi Peo

glad someone's awake ... i decided to test it before sending and then for
some reason copied & pasted the incorrect info over what i had originally
written ... think it's time to go to bed :)

Cheers
JulieD
 
S

SU

Peo + Julie Many thanks for that.
Have another similar question; would the same method work with values form a
different spreadsheet?

i.e. I type the link (as text) from a different spreadsheet in a cell in
current spreadsheet and use this method to call a value in a cell.

Appreciate your help.
 
Top