YES! apologies ... you need Laurent Longre's MOREFUNC add-in.

"Teethless mama" wrote:

EVAL function give me an error #NAME? Excel stand alone won't reqconize this
function unless you have some kind add in more functions to your Excel. Am I
correct?

"Toppers" wrote:

=EVAL(A1)

"Teethless mama" wrote:

=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