excel text function

[bumgr]

How do I can extract particular values from long text written in uneven way
e.g.

1. CO 40/2 AOE (40%) CL 35 AAR (60%)
2. CL 40/2 AAR (66.67%) AR 34 RRR (33.34%)

Now I want to extract from no. 1 is 40% and 60%
and from No. 2 is 66.67% and 33.34%

How I can >

 

[Robert Mika]

Hi
For the first numer in B1 =MID(A1,FIND("(",A1)+1,3)
for the second numer in C1: =MID(A1,FIND("&",SUBSTITUTE(A1,"(","&",2),3)+1,3)

 

[machopicho]