Thread: Formula help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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