Excel formula to extract a word by searching the starting letters of the word till 9 characters

Column A Ticket number IM1764841 for LOS is already kept open I see an IM1876561 for HW failure in this site Duplicate Ticket No IM1635462   I need a excel formula to extract the ticket number f...