How to get the result of adding several numbers into one cell with a plus sign (+)

[Hany ali]

Dear teachers ... I want you help in my problem ,how to get sum Result for this 100+200+300 from one Cell ... it must be the Result 600
if you can to change in this Formula

=IFERROR(MID($B2,1,FIND("+",$B2,1)-1)+MID($B2,FIND("+",$B2,1)+1,9^9),$B2)

 

[deciog]

Hany ali

Check if this is how you want it

Decio

 

[Hany ali]

Well done, my dear teacher, and he is really required
Thank you very much ... To you, Muna, all the greetings and respect, and may God bless you
thanks
@pecoflyer ,but I cant Used this because i work in Excel 2010 ,and this formula EVALUATE ,Not Define !!

 

[pecoflyer]

Check the following https://www.myonlinetraininghub.com/excel-factor-12-secret-evaluate-function