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.

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.

How about

=INDIRECT(A2)

<g

--

Regards,

Peo Sjoblom


"JulieD" wrote in message
...
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.

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

"Peo Sjoblom" wrote in message
...
How about

=INDIRECT(A2)

<g

--

Regards,

Peo Sjoblom


"JulieD" wrote in message
...
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.

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.

"Peo Sjoblom" wrote:

How about

=INDIRECT(A2)

<g

--

Regards,

Peo Sjoblom


"JulieD" wrote in message
...
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.