'Evaluate a Google Sheets math expression with formula

I have some strings inside Google Sheets, containing simple arithmetic expressions:

enter image description here

Is there a way to evaluate these expressions without the need for writing a script? (i.e. formula only)



Solution 1:[1]

try:

=INDEX(QUERY(; "select "&A6); 2)

enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 player0