How to split components of an equation

[jbenfleming]

Say I have the following formula in cell A1: "=100+500"

how do I pull that 500 from the formula and put it in B1 using a formula?

 

[mikerickson]

Select B1 and define this Name

Name: Formula
RefersTo: =GET.CELL(6, Sheet1!$A1)


Then the formula (put in B1) =MID(Formula,FIND("+",Formula&"+")+1, 255) will return the string "500". (i.e. everything after the first "+" in the formula.)

 

[jbenfleming]

Ended up putting this in B1: =RIGHT(FORMULATEXT(A1),LEN(FORMULATEXT(A1))-FIND("+",FORMULATEXT(A1)))

I like your solution though. Not a way I would normally be thinking. Always good to get new perspectives in Excel. Thank you!