View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Charles Williams
 
Posts: n/a
Default 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!