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