How to Convert a String into a Formula in Excel

,

This post will guide you how to convert a string into a formula in Excel. How do I turn test strings to a formula for calculation.

Convert a String into a Formula


Assuming that you have a list of data in range C1:C4, which contains text string (Actually, they are all formulas, but they are shown as text string format), and you want to convert those test string into a formula for calculation. How to do it. You can create your own Excel Functions with VBA Code. It is also called as a User Defined Function. And it work the same way as Excel’s build-in standard functions. Just do the following steps:

#1 open your excel workbook and then click on “Visual Basic” command under DEVELOPER Tab, or just press “ALT+F11” shortcut.

 Get the position of the nth using excel vba1

#2 then the “Visual Basic Editor” window will appear.

#3 click “Insert” ->”Module” to create a new module.

convert column number to letter3

#4 paste the below VBA code into the code window. Then clicking “Save” button.

convert string to formula1

Function EvaluateString(strTextString As String)
     Application.Volatile
     EvaluateString = Evaluate(strTextString)
End Function

#5 back to the current worksheet, then type the following formula in a blank cell, and then press Enter key. And drag the AutoFill Handle over to other cells.

=EvaluateString(C1)

convert string to formula2

You would notice that all  strings in range C1:C4 have been converted as formulas.

 

 

Leave a Reply