Hi;

i need to convert a text from a cell that is already a simple math formula (example: 50+60) to an actual formula in another cell (basically add the “=” at the beggining) in order to solve the expression without changing anything in the first cell

I need it to be automatic with no “find&replace”, i’m already using the ="="&A1 solution in order to add the = symbol and convert it afterwards from text to operator with “find&replace” but i need to skip the last part.

there is a solution i can implement? i can use as many cells/sheets as needed.

to better explain myself

A1 is 50+60-10…etc… with no “=” sign

A2 have to solve what is inside A1