Formula help
In B1 enter:
=MID(A1,2,1)+MID(A1,4,1) & "+" & MID(A1,8,1) *MID(A1,10,1)
In C1 enter:
=RIGHT(B1,2)+LEFT(B1,1)
--
Gary''s Student - gsnu2007d
"Stelios" wrote:
I am using a way to do the following
column1 column 2 column 3
(2+3)+(3*5) 5+15 20
in the first column I want to be able to see the expresion
in the second column I want to have the result of each parenthesis
and in the final column the result
Please help
Thanks
Stelios
|