If your data always start with the number and there is no chance there
will be a second number in the string, then the following *array*
formula will extract the number in another column:

=VALUE(LEFT(A2,MAX(ROW(1:100)*ISNUMBER(VALUE(LEFT( A2,ROW(1:100)))))))

Array formulas must be committed with Shift+Ctrl+Enter.

HTH
Kostis Vezerides