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.
1. 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](https://www.excelhow.net/wp-content/uploads/2017/11/Get-the-position-of-the-nth-using-excel-vba1.jpg)
#2 then the “Visual Basic Editor” window will appear.
#3 click “Insert” ->”Module” to create a new module.
![convert column number to letter3](https://www.excelhow.net/wp-content/uploads/2017/12/convert-column-number-to-letter3.jpg)
#4 paste the below VBA code into the code window. Then clicking “Save” button.
![convert string to formula1](https://www.excelhow.net/wp-content/uploads/2019/03/convert-string-to-formula1.gif)
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](https://www.excelhow.net/wp-content/uploads/2019/03/convert-string-to-formula2.gif)
You would notice that all strings in range C1:C4 have been converted as formulas.
2. Video: Convert a String into a Formula
This Excel video tutorial explores an advanced Excel technique that converts what appear to be mere strings into powerful, calculable formulas, adding a new dimension to your spreadsheet capabilities.
Leave a Reply
You must be logged in to post a comment.