=LEFT(A1,FIND("+",A1)-1)+RIGHT(A1,FIND("+",A1)-1)


"Robert" wrote:

Hi
I am newbie with Excel, and can not find how to calculate this:

A B
2+3 5

ie. I will enter 2+3 (into A) , and B need to display 5.
If I write =SUM(A1) into B cell, I become 0.

Thank you