extract numbers from text

hi,

how can i extract the 123.3 from "123.3 euros" the amount could always be different as can be the text

thanks
steve

If the amount is always at the start and followed by a space

=LEFT(A1,FIND(" ",A1)-1)+0

The array formula
=MAX(IF(ISERROR(VALUE(LEFT($A$1,ROW(A1:A30)))),0,VALUE(LEFT($A$1,ROW(A1:A30))))) (entered with Contol-Shift-Return)
will return the value of the numeral starting the text in A1.

Daddylonglegs formulation is better (faster, easier to edit), but requires the data to be in a set format.