| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel save as csv - force text qualifier on every text field | Excel Discussion (Misc queries) | |||
| How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
| dates and text | Excel Discussion (Misc queries) | |||
| Force values-only when pasting text to keep formatting | Excel Discussion (Misc queries) | |||
| Cell text based on 4 condition test | Excel Worksheet Functions | |||
Linear Mode
