View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Simple calculating ...

=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