Search code examples
arraysgoogle-sheetssumspreadsheetgoogle-query-language

Reading a cell text as a Formula

I want excel (and google spreadsheets) to read a text as a formula.

Cell A1: 1+2

Cell A2: =readAsFormula(A1)

So cell A2 should show 3.

Can`t find any way to do it, and I wanted to avoid making a custom function for it.

Any ideas?

Solution

  • in google sheets use in cell A2:

    =QUERY(;"select "&A1)