MID FUNCTION

Iron 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...???

4 Replies

@Excel 

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

It should come W320 only with the help of MID FUNCTION

@Excel 

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

Hi @Excel 

 

Is it always required to find W320 ? 

Would you please give us another example in order to understand your requirement