Forum Discussion

rajeshk2610's avatar
rajeshk2610
Copper Contributor
May 18, 2018

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 from the above cells in a column, by searching the word "IM". Ticket number will be having the character length as 9. My output should be as below

 

IM1764841

IM1876561

IM1635462

 

Any body can help me on this...? Thanks in advance

Resources