Results 1 to 4 of 4

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

Threaded View

fk_ Formula to search specific... 02-12-2020, 09:08 AM
Fluff13 Re: Formula to search... 02-12-2020, 09:35 AM
fk_ Re: Formula to search... 02-12-2020, 10:11 AM
Fluff13 Re: Formula to search... 02-12-2020, 10:26 AM
  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

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