Dec 21 2020 03:52 AM
Hi, please, I have a list of products with a Description column where there is a description of each product. From this column I need to extract the words from the list of 130 words into a cell in the same product row and to:
1) Make it work without case sensitivity.
2) Take into account words that have a certain character behind / in front of them, for example: comma, dot, semicolon, asterisk *, exclamation mark.
3) Not to take into account words that are part of other words.
4) A bonus would be if the formula / script could have a list of words to ignore, for example: PU leather, PU-leather.
I will be very grateful for any help.
Dec 21 2020 08:37 PM
It would be great if you please attach a sample file with few records
Regards, Faraz Shaikh
Dec 22 2020 03:06 AM