Extracting numbers from text?

I have tried both and neither work, on my sheet, it may be that i have simplified the data im trying to extract the number from, which is in a data table, but i did try Pepe's link which i found this formula from and this works perfect

=1*MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$9),1)),0),COUNT(1*MID(A1,ROW($1:$9),1)))

Im going to keep trying with both your formulas as if it works for you two, it surely must work for me,

Thank you all