Try this formula

=IFERROR(AGGREGATE(14,6,MID(A1,ROW(INDIRECT("1:"&LEN(A1))),{6,7})+0,1),"No number")