Menu
I have 0,4*A1 in a cell (as a string). How can convert this "string formula" into a real formula and calculate its value, in another cell?
860
Using Keyboard Shortcut Select the cells for which you want to convert formulas to values. Copy the cells (Control + C). Paste as Values – Keyboard Shortcut – ALT + ESV.
Use the INDIRECT function in Excel to convert a text string into a valid range reference. For example, use SUM and INDIRECT. Explanation: the formula above reduces to =SUM(INDIRECT("D3:D6")). The INDIRECT function converts the text string "D3:D6" into a valid range reference.
Evaluate might suit:
http://www.mrexcel.com/forum/showthread.php?t=62067
Function Eval(Ref As String) Application.Volatile Eval = Evaluate(Ref) End Function If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
