+ Reply to Thread
Results 1 to 4 of 4

Formula to search specific set of terms in a string and return any found terms

  1. #1
    Registered User
    Join Date
    10-31-2019
    Location
    Europe
    MS-Off Ver
    365
    Posts
    7

    Question Formula to search specific set of terms in a string and return any found terms

    Hello.

    I have a set of strings (="strings" column) and would to like to parse through them and search for specific terms (=the green cells). Then the formula should return all the terms it found in the string in comma delimted format (see "Expected Result" column)

    EDIT: sample data for the screenshot was attached to this post
    Untitled.jpg

    I was working with IF, ISNUMBER and SEARCH functions, but so far did not reach my expected result.

    Thank you for your help
    fk_
    Attached Files Attached Files
    Last edited by fk_; 02-12-2020 at 10:11 AM. Reason: solved

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Formula to search specific set of terms in a string and return any found terms

    How about
    =TEXTJOIN(",",1,IF(ISNUMBER(SEARCH($A$19:$A$27,A2)),$A$19:$A$27,""))

  3. #3
    Registered User
    Join Date
    10-31-2019
    Location
    Europe
    MS-Off Ver
    365
    Posts
    7

    Re: Formula to search specific set of terms in a string and return any found terms

    Works like a charm. Thank you very much Fluff13!

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Formula to search specific set of terms in a string and return any found terms

    You're welcome & thanks for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Help to modify formula so that combinations of search terms are used
    By Thintin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-11-2019, 08:20 AM
  2. Replies: 2
    Last Post: 08-15-2018, 06:29 AM
  3. Replies: 1
    Last Post: 01-26-2015, 04:42 PM
  4. Can you Remove Terms from a String using a formula?
    By afriedman in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 09-16-2014, 11:00 AM
  5. Seeking Formula to separate cells that contain specific terms
    By syncguy in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-19-2014, 03:19 AM
  6. Truncate text strings using LEFT and FIND/SEARCH for multiple search terms
    By ngdoherty in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-17-2013, 07:51 PM
  7. Replies: 9
    Last Post: 11-03-2010, 11:42 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1