Max, same problem as with Niek's reply. Apols again.

Rgds,
Andy


"Max" wrote in message
...
One way

With A1 containing: "0.120;0.140;0.200"

This seems to work in say, B1:


=LEFT(A1,SEARCH(";",A1)-1)+MID(A1,SEARCH(";",A1)+1,SEARCH(";",A1,SEARCH("; ",
A1)+1)-SEARCH(";",A1)-1)+MID(A1,SEARCH(";",A1,SEARCH(";",A1)+1)+1,99)