How do I convert a text string to a formula in Excel?
How do I convert a text string to a formula in Excel? For a non-VBA solution, use the INDIRECT formula. It takes a string as an argument and converts it to a cell reference. For example, =0.4*INDIRECT("A1") will return the value of 0.4 * the value that's in cell A1 of that worksheet. If cell A1 was, say, 10, then =0.4*INDIRECT("A1") would return 4. How do I extract data from a text string in Excel? Using Text to Columns to Extract a Substring in ExcelSelect the cells where you have the text.Go to Data –> Data Tools –> Text to...