Toppers

I think you forget something................

Function Eval(RefCell As String)
Application.Volatile
Eval = Evaluate(RefCell)
End Function


Gord Dibben MS Excel MVP

On Sat, 28 Apr 2007 09:06:03 -0700, 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