+ Reply to Thread
Results 1 to 8 of 8

VBA looking for multiple keywords and return concatenated keywords, that were found

  1. #1
    Registered User
    Join Date
    11-09-2009
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel 2013
    Posts
    4

    VBA looking for multiple keywords and return concatenated keywords, that were found

    Hello team,
    I hope you can help me with this challenge
    I have a text column A, and two large lists of keywords. Once keywords lookup is done-all keywords should be concatenated in single cell, separated by symbol #.

    - Column A contains long text,
    - Column B should return keywords-from-list-1(100 keywords) found into the text
    - Column C should return keywords-from-list-2(200 keywords) found into the text

    example:
    A2 = The Frog King, or Iron Henry
    B2 = Frog#Henry //as "Frog" and "Henry" are keywords in my first list (100 keywords)
    C2 = Iron#King //as "iron" and "king" are keywords in my second list (200 keywords)

    thank you for any help you can provide!
    cheers\kpacu
    Last edited by Kpacu007; 07-09-2014 at 11:49 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    564

    Re: VBA looking for multiple keywords and return concatenated keywords, that were found

    A workbook with the lists and end result would be welcome
    ________________________________________________________
    If your problem is solved, update the thread as SOLVED: Go to the top of the first post-Select Thread Tools-Select Mark thread as Solved OR - Go to the first post - Click edit- Click Advance- Just below the word "Title:" you will see a dropdown with the word No prefix.- Change to Solve- Click Save.

    Show your gratitude to the person who helped you solving your problem by clicking on star button at the bottom of such post.

  3. #3
    Registered User
    Join Date
    11-09-2009
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: VBA looking for multiple keywords and return concatenated keywords, that were found

    thanks for prompt reply, Haripopuri,
    attached is a file with sample
    best regards\Kpacu
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,991

    Re: VBA looking for multiple keywords and return concatenated keywords, that were found

    Try this
    Please Login or Register  to view this content.

  5. #5
    Valued Forum Contributor
    Join Date
    11-02-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    564

    Re: VBA looking for multiple keywords and return concatenated keywords, that were found

    May be this one.
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    11-09-2009
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: VBA looking for multiple keywords and return concatenated keywords, that were found

    Hello Jindon, Haripopuri,

    Both work perfectly, this is great!!!!

    thank you so much!!!!
    Last edited by Kpacu007; 07-10-2014 at 05:49 AM.

  7. #7
    Registered User
    Join Date
    11-09-2009
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: VBA looking for multiple keywords and return concatenated keywords, that were found

    Thanks, it works!

  8. #8
    Valued Forum Contributor
    Join Date
    11-02-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    564

    Re: VBA looking for multiple keywords and return concatenated keywords, that were found

    Glad we could help. Please update the thread as SOLVED and you may wish to add to our rep.

+ 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. VBA Code to search keywords, then highlight when found
    By koz81 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2014, 05:52 PM
  2. [SOLVED] Search for keywords and copy rows containing keywords to new sheet
    By lenorsk in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-15-2013, 06:54 AM
  3. [SOLVED] Look for a list of keywords in a cell and then return the content of the found cell
    By RasmusClark in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-10-2013, 04:50 AM
  4. [SOLVED] HDI - Return multiple keywords in a text column based on a set of available keywords
    By zneiley in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-25-2013, 01:32 PM
  5. Replies: 2
    Last Post: 11-24-2010, 05:44 PM

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