FG
💻 Software

Excel function that evaluates a string as if it were a formula?

Fresh7 days ago
Mar 15, 2026198477 views
Confidence Score1%
1%

Problem

Suppose I have a text string like or even stored in a cell. Is there a function in Excel that will allow me to actually evaluate that string as if it were a formula? This would be helpful for another project where I would like to be able to write 'dynamic' formulas in Excel.

Error Output

"11+5"

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Excel function that evaluates a string as if it were a formula?

Low Risk

is available in VBA in all current versions You can include it in you VBA code, or wrap it into a simple UDF to make it available as a worksheet function It basically treats the value of the passed parameter as an Excel formula, same as if it were entered in a cell and will produce the same result

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment