| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
evaluating text as if it were a formula
Suppose I have text in cell A3 such as "2+1/4". I want Excel 2003 to evaluate
that as a formula and put the resulting value - namely 2.25 - in another cell. Can it do this? I have a vague memory, perhaps of another spread sheet, that one could say =EVAL(A3), but Excel doesn't seem to have the capability. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| evaluating text of cells | Excel Discussion (Misc queries) | |||
| Lookup formula not evaluating correctly | Excel Discussion (Misc queries) | |||
| evaluating text cell contents | Excel Discussion (Misc queries) | |||
| If formula evaluating 2 cells contents | Excel Worksheet Functions | |||
| Evaluating similarity of text strings | Excel Worksheet Functions | |||
Threaded Mode
