Try this formula. It might help
=IFERROR(VALUE(MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),6)), LOOKUP(2,1/--MID(A1,MIN(INDEX(FIND(ROW($1:$10)-1,A1&1/17),,)),ROW(INDIRECT("1:"&LEN(A1))))))