+ Reply to Thread
Results 1 to 4 of 4

Search cell for multiple text , return comma separated text in separate cell if found

  1. #1
    Registered User
    Join Date
    09-30-2013
    Location
    canada
    MS-Off Ver
    Excel for Mac 2011
    Posts
    4

    Search cell for multiple text , return comma separated text in separate cell if found

    I'm very new at this, my terminology will not be good.

    I have two columns that I'm working with. In one column, I have a macro that lets me select multiple options from a drop down list of 50+ options, and it will return those values in the cell separated by commas.

    I want the 2nd column to search each cell for which values have been selected, and based on that, return a separate set of comma separated values.

    the logic behind is it the 50+ options are subcategories, and the 2nd column will be master categories. so one cell would look like

    ax,ay,az a
    ax,by,bz a,b
    ax,by,cz a,b,c

    thank you very much

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Search cell for multiple text , return comma separated text in separate cell if found

    One would need to build an equivalence table (pairs e.i. ax,a by,b cz,c) so in the same macro it could search for the selection and then "translate" to your desired result and place it in the proper column.

  3. #3
    Registered User
    Join Date
    09-30-2013
    Location
    canada
    MS-Off Ver
    Excel for Mac 2011
    Posts
    4

    Re: Search cell for multiple text , return comma separated text in separate cell if found

    okay, so i've built the equivalence table. what's my next step?

  4. #4
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Search cell for multiple text , return comma separated text in separate cell if found

    change the code into the macro so instead of writing the item it searches in your newly created table and writes its equivalent.

+ 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] Formula to Extract Phrase in Cell to Comma Separated Text
    By ghoneim in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-04-2013, 09:44 AM
  2. Vlookup pulling two cells or more of text into one cell separated by a comma
    By ThePainter in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-16-2013, 08:14 PM
  3. [SOLVED] separate cell with comma separated data into one column
    By Tenos in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-12-2012, 02:45 PM
  4. Replies: 4
    Last Post: 05-12-2011, 02:25 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