Extracrting string from cell - still getting error

[rangequestion]

Hi,

I have multiple rows where my cells look something like this: "+USD 17,286.24" or "-USD 40,918.66" . I just want to extract the number and I'm using this formula:
=RIGHT(F9,(FIND(" ",F9,1)-1))
which works on every other cell I have except where the format reads like my examples above.

Any ideas?

 

[rangequestion]

Returns nothing. Although it works for other cells in the workbook

 

[rangequestion]

This formula works though. I had to add 242 instead of 1:
=(MID(F11,5,242))

 

[Rick Rothstein]

Okay, try this formula then...

=REPLACE(F9,1,FIND(" ",SUBSTITUTE(F9,CHAR(160)," ")),"")

 

[rangequestion]

Yes! thanks!!