Forum Discussion
rajeshk2610
May 18, 2018Copper Contributor
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
1 Reply
Sort By
- Detlef_LewinSilver Contributor
Hello,
=MID(A1,SEARCH("IM",A1),9)