Quick answer: Excel does not have a regular worksheet function that evaluates arbitrary formula text stored in a cell. In desktop Excel, you can create a small VBA user-defined function using Application.Evaluate, then call it from another cell. This tutorial shows the code, explains its limitations, and covers common errors. Only evaluate trusted formula strings: avoid running expressions supplied by unknown users. Example: calculate a formula stored as text Suppose… Read More »How to Evaluate a Formula Stored as Text in Excel (VBA)
