Hello Everyone,
Would it be possible to pull specific keywords from a text string.
As an example, you will find list of keywords in Column D and the result that I am expecting is in column B. For example: 'wowhead' is listed as a keyword in column D and it is found in the first title so the result should be 'wowhead' in column B, similarly, 'property' and 'certificates' are also listed in column D and both keywords are mentioned in title 2 hence the result should be 'property, certificates' in column B and so on.
Please let me know if this can be achieved by using excel formula or VB script.
Would it be possible to pull specific keywords from a text string.
As an example, you will find list of keywords in Column D and the result that I am expecting is in column B. For example: 'wowhead' is listed as a keyword in column D and it is found in the first title so the result should be 'wowhead' in column B, similarly, 'property' and 'certificates' are also listed in column D and both keywords are mentioned in title 2 hence the result should be 'property, certificates' in column B and so on.
Please let me know if this can be achieved by using excel formula or VB script.
![2015-08-07_10h19_36.jpg](/board/proxy.php?image=http%3A%2F%2Fi13.photobucket.com%2Falbums%2Fa262%2Frajtak%2F2015-08-07_10h19_36.jpg&hash=6a0f887d35e8627d38dfe65632a4f19e)