MID FUNCTION

[Zan_Hanifee]

Hello Everyone, 

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

like - 

Please help...???

[#2]

@Zan_Hanifee 

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

[#3]

It should come W320 only with the help of MID FUNCTION

[#4]

@Zan_Hanifee 

=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.