Hi,

The following ARRAY formula will exctract a numerical fragment from cell A2.

=1*MID(A2,MATCH(TRUE,ISNUMBER(1*MID(A2,ROW($1:$9),1)),0),COUNT(1*MID(A2,ROW($1:$9),1)))
Please modify as you require.

An array formula must be entered using CTRL, SHIFT and ENTER.