You can't do it with any built in excel functions...
But you can use this method... which kinda feels like an Excel function...
Go to Formula tab, then select Define Name in the Defined Names section. Enter the word Formula in Name field, and enter formula in the Refers to field: =GET.CELL(41,OFFSET(INDIRECT("RC",FALSE),0,-1))
Click Ok.
Now, assuming you can have operators, +, -, * and / place this formula in cell directly to the right of cell you want to evaluate:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Formula,"=",""),"+"," "),"-"," "),"*"," "),"/"," ")
This should repace all the operators including the = with a space.
in next cell over enter formula:
=IFERROR(0+TRIM(MID(SUBSTITUTE($B1," ",REPT(" ",100)),1+(100*(COLUMNS($A$1:A$1)-1)),100)),"")
where $B1 is cell you put the first formula in... and copy across as far as you need.... you can then copy down if you have more...
NOTE: You will need to enable macros for this to work. It uses older XL4 MACRO to work.
Bookmarks