MID FUNCTION

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

@Zan_Hanifee 

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

It should come W320 only with the help of MID FUNCTION

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