Apr 04 2022 07:16 AM
Hello Everyone,
VIETNAMESE CASHEW KERNEL W320 HSCODE 080132=> Here we need to get answer W320 with the help of formula?
like -
Please help...???
Apr 04 2022 07:35 AM - edited Apr 04 2022 07:42 AM
It should come W320 only with the help of MID FUNCTION
Apr 04 2022 07:44 AM
=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.
May 30 2022 12:54 PM
Hi @Excel
Is it always required to find W320 ?
Would you please give us another example in order to understand your requirement