I have a spreadsheet that generates formulae as text ex.
=CONCATENATE("+B",ROW(),"*",ROUND(G5,2))
output:
+B5*1464.41
I have a column of this type of text that I need to convert into individual formulae. Right now, I copy the text to a new column, and then push the '=' button for each row. Is there a way to automate this? or do it in bulk?
Evaluate()
function, so you'd have to figure out how to call a function in another language (such as JavaScript or Python).