Adding/subtracting numbers in same cell

[rpoppy]

Hello! If I have multiple numbers in the same cell is it possible to add or subtract them? For example I have a cell that says "Funding costs decreased from $500 by $400" so the next cell over needs to show the current amount which would be "$100."

Is there a way to do this without having to manually add or subtract the numbers and input the amount? Thank you in advance!

- rpoppy

 

[Scott Huish]

Are the surrounding words always the same? What is the wording for an increase?

 

[rpoppy]

It is the same wording. It would read "Funding costs incresed from $100 by $400" and the next cell would say "$500"

Thanks!

 

[Scott Huish]

=ABS(REPLACE(LEFT(A1,FIND("by",A1)-1),1,30,"")-TRIM(RIGHT(SUBSTITUTE(A1,"$",REPT(" ",255),2),255)))

 

[rpoppy]

Thanks! That helped a lot. The only problem is that it only decreases the two numbers and sometimes they need to be increased. Is there a way to make it so that it will do both depending on the wording inside the cell?

 

[Scott Huish]

=IF(MID(A1,15,9)="decreased",REPLACE(LEFT(A1,FIND("by",A1)-1),1,30,"")-TRIM(RIGHT(SUBSTITUTE(A1,"$",REPT(" ",255),2),255)),REPLACE(LEFT(A1,FIND("by",A1)-1),1,30,"")+TRIM(RIGHT(SUBSTITUTE(A1,"$",REPT(" ",255),2),255)))