force evaluation of text
 

In cell A1 I have the value B and in cell A2 I have the value 6.

I want cell A3 to have the value of cell B6. I can get A3 to read B6 but no
to give me the value that is sitting in B6 (3512).

Is it possible to force the evalution of A3 (currently =A1&A2)
Thanks!

force evaluation of text
 

=INDIRECT(A1&A2)


--
Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"Light" wrote in message
...
In cell A1 I have the value B and in cell A2 I have the value 6.

I want cell A3 to have the value of cell B6. I can get A3 to read B6 but
no
to give me the value that is sitting in B6 (3512).

Is it possible to force the evalution of A3 (currently =A1&A2)
Thanks!

force evaluation of text
 

Check out the INDIRECT function; it is used for converting text to an actual
cell reference.

In the case you gave, you would type in cell A3: =INDIRECT(A1 & A2)

"Light" wrote:

In cell A1 I have the value B and in cell A2 I have the value 6.

I want cell A3 to have the value of cell B6. I can get A3 to read B6 but no
to give me the value that is sitting in B6 (3512).

Is it possible to force the evalution of A3 (currently =A1&A2)
Thanks!

force evaluation of text
 

Perfect, thank you!

"Charles Williams" wrote:

=INDIRECT(A1&A2)


--
Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"Light" wrote in message
...
In cell A1 I have the value B and in cell A2 I have the value 6.

I want cell A3 to have the value of cell B6. I can get A3 to read B6 but
no
to give me the value that is sitting in B6 (3512).

Is it possible to force the evalution of A3 (currently =A1&A2)
Thanks!