• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pull some words from a sentences in a range basis some keywords list

I want to pull certain keywords from a sentence basis some list of keywords.

For e.g. Cell A3 has a sentence: "Sumit has consulting experience". Cell B3 should return Consulting. Similarly in other rows there would be different sentences with different keywords, and separate sheet would have list of keywords which I would want to return from column A.

Details are in the attachment.



  • Pull Keyword from a range basis some criterias.xlsx
    10 KB · Views: 3
See attached formula in cell B3:
=TEXTJOIN(", ",TRUE,FILTER(Keywords[Keyword],NOT(ISERR(SEARCH(Keywords[Keyword],A3))),"None"))
Your keywords list has been made into a proper Excel Table.



  • Chandoo56564Pull Keyword from a range basis some criteria.xlsx
    12.1 KB · Views: 2