Pulling Numbers out of a text string (+123.94 $ etc.)

Hello, I am a long list of numbers that are pasted in and look like this
+123.45 $
+12.19 $
-1.90 $
-.01 $

The + indicates a positive number and the - means a negative number. I need them to be converted into a number. I am having trouble converting them to where I am keeping whether or not the are positive or negative and also not losing decimal places since the numbers can be different lengths. Any help is appreciated. Thanks

One way...

=--SUBSTITUTE(A1," $","") then drag down as you need.

That gets me a #VALUE! error

Originally Posted by CMO177

... #VALUE! error

How do you have formatted cells ?

Ps.: And something like that ?
=LEFT(A1,FIND(" $",A1)-1)
or
=VALUE(LEFT(A1,FIND(" $",A1)-1))