Calculate a chopped string

[scrupul0us]

Given cell O37:
10 HOURS @ 35$/HOUR

Formula in P37:
=LEFT(O37,2)*(LEFT(O37,13)-LEFT(O37,11))

Returns:
#VALUE

LEFT(O37,2): should return 10
(LEFT(O37,13)-LEFT(O37,11)): should return 35 but i beleive is where the error lies

Any help? TY

 

[just_jon]

=LEFT(A1,FIND(" ",A1)-1)*MID(A1,FIND("@",A1)+1,FIND("$",A1)-1-FIND("@",A1))

Assumes the structure is static as above.

 

[Todd Bardoni]

=LEFT(O37,FIND(" ",O37))*SUBSTITUTE(LEFT(O37,FIND("$",O37)-1),LEFT(O37,FIND("@",LEFT(O37,FIND("$",O37)-1))+1),"")

Not as clean as Jon's, but just another way of doing things...