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

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

CodePudding user response：

try:

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