Super Contributor

Hello Everyone, 


VIETNAMESE CASHEW KERNEL W320 HSCODE 080132=> Here we need to get answer W320 with the help of formula?

like - 

Screenshot (6716).png


Please help...???

3 Replies


Will the next to last "word" always be HSCODE?

It should come W320 only with the help of MID FUNCTION


=MID(A1,SEARCH(" W??? ",A1)+1,4)

Maybe with this formula if the result is somewhere in the middle of the text and if it always starts with "W" and has 4 digits.