Hi Rich

=LOOKUP(9.9E+307,1*LEFT(MID(A1,MIN(FIND({0,1,2,3,4 ,5,6,7,8,9},A1&"0123456789")),999),ROW($1:$999)))

this formula is not extracting all digits from alphanumeric value

My Input was a0-112455jkjk223
and result is coming 0