Formulate a text string to equal a numerical value

[aaronpearson]

Hello experts,

I sell products on an online auction website (Buy online and sell with NZ's #1 auction & classifieds site | Trade Me)
This website has a feature where you can export ''Sold Products'' to excel.

My problem is when I use this feature, the data that is exported relating to the freight costs for each sale is not exported as a numerical value only. (RIDICULOUS!!)

I have 3 different freight options for my costumers.
Depending on which freight option the costumer selects, the data is exported to one cell as follows:

$5.90 Courier (tracked) - 2-3 days - NOT Rural Delivery
Or
$7.90 RURAL DELIVERY - Courier- 3-4 working days
Or
$1.50 I HAVE PAID POSTAGE ABOVE - Combined Postage


I am in the process of creating a 'Daily Sales Report' Sheet where I need to have only the numerical value of the freight costs only without the description. For example I need the data above to be formulated in a different cell to equal:

5.90
Or
7.90
Or
1.50

Im sure this is very basic, I am very new to excel and any help would be greatly appreciated.

 

[steve the fish]

One way that would extract the numbers from your examples would be. This is conditional on the numbers being at the front as in the examples.

=SUBSTITUTE(LEFT(A1,FIND(" ",A1)-1),"$","")

 

[Aladin Akyurek]

Try...

=LEFT(A2,FIND(" ",A2))+0

 

[István Hirsch]

If there are not blank cells and the data start in A1, put in B1 and copy down:

=MID(A1,2,4)+0