Extracting numbers of varying length from a string

Hi there,

I have been unable to find a workable solution to this problem elsewhere. I've tried a few different things, but haven't been able to come up with a reliable method.

I want to extract two numbers from a string into two separate cells, however the length of the numbers can vary each time. The start of the string is always the same i.e. "Solution(" , and the numbers are always separated by a semi colon.

Solution(9.51; 9.1044)
Solution(0.08847; 0.06728)
Solution(5.1826; 215.02)

Say for example, Solution(9.51; 9.1044) is in A1, I want to extract the number 9.51 into B1, and 9.1044 into C1.

Any help would be much appreciated

Try,

B1

=MID(A1,FIND("(",A1)+1,FIND(";",A1)-FIND("(",A1)-1)+0

C1,

=SUBSTITUTE(MID(A1,FIND(";",A1)+1,250),")","")+0

copy down.

Formula in Cell B1 :

PHP Code: 

=--MID(A1;FIND("(";A1)+1;FIND(";";A1)-FIND("(";A1)-1) 


Formula in Cell C1 :

PHP Code: 

=--MID(A1;FIND(";";A1)+1;LEN(A1)-FIND(";";A1)-1) 


NOTE :Format decimal in control panel has to be "," to show results desire with format NUMBER
Thanks!