Assuming my assumption above is right, here's a classic lazy one. You could find many better variants around if you searched well enough though.

=MID(SUBSTITUTE(TRIM(A1)," ","|",LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ",""))-1),FIND("|",SUBSTITUTE(TRIM(A1)," ","|",LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ",""))-1))+1,8)

If I were to add another assumption that the first numeric character in the entire text string will be the one immediately after the first character of the text patter you want to extract, then this will also work

=MID(A1,SUMPRODUCT(MIN(IFERROR(FIND(ROW(OFFSET($A$ 1,,,10,))-1,A1),FALSE)))-1,8)