Convert Text Strings To Formulas In Excel

https://www.extendoffice.com/documents/excel/1683-excel-convert-text-string-to-formula.html

The following short VBA code can help you to deal with the problem that convert text to formula as these steps:

1. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and paste the following code in the Module Window.

VBA code: Convert text strings to formulas

1 2 3 4

Function Eval(Ref As String) Application.Volatile Eval = Evaluate(Ref) End Function

3. Save this code and return to your worksheet, enter this formula =Eval(C1) into a blank cell (C1 contains the text string cell which you want to convert to formula), see screenshot: