how to get numbers from this value

[bezbid]

cell O9 = "12.55 - 100.35"

P9 = 100.35
P10 = 12.55
what is the formula for the cell P9 and P10 to get the value as above?

P9 = MID(O9,FIND("-",O9)+2,10) is this the right formula?
P10 =?

[AlKey]

To get left part

Please Login or Register  to view this content.

To get right part

Please Login or Register  to view this content.

[Phuocam]

or to get right part...
=--REPLACE(O9,1,FIND("-",O9),"")

[bezbid]

you guys rock

[Tony Valko]

Here's a couple more...

P9: =--LEFT(O9,FIND(" ",O9))

P10: =--SUBSTITUTE(O9,P9&" - ","")