+ Reply to Thread
Results 1 to 3 of 3

Combine multiple text cells if value exists in other cells

  1. #1
    Registered User
    Join Date
    02-01-2012
    Location
    saved Chinkon
    MS-Off Ver
    Excel 2007
    Posts
    3

    Combine multiple text cells if value exists in other cells

    Trying to help out with a form, cant seem to figure out how to combine multiple long text cells. Using if errors out stating that it cant handle more than 255 characters. Currently copying to another cell with multiple if's then concatenating to another cell, but this seems cumbersome. Tried to figure out vlookup but I cannot make it work. Any suggestions?

    A simplified picture looks like this:

    info selection
    1 text1 x
    2 text2
    3 text3 x
    4 text4 x
    5
    6 text1
    text3
    text4
    7

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,389

    Re: Combine multiple text cells if value exists in other cells

    Welcome to the forum, far better if you describe the witth sample workbook with before and after scenario, maybe it can attract the solver to figure it out the problem faster

    Regards
    Azumi

  3. #3
    Registered User
    Join Date
    02-01-2012
    Location
    saved Chinkon
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Combine multiple text cells if value exists in other cells

    Here is one sheet of this workbook. If you place an X in the fields of columns d through j then the comments of column j combine and appear in c24. If its too difficult to copy comments, that same text can be placed in different cells, as long as the result is the same.
    Attached Files Attached Files

+ 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] Combine multiple cells text into one cell, skip blank cells.
    By T15K in forum Excel General
    Replies: 6
    Last Post: 12-05-2014, 09:49 PM
  2. [SOLVED] combine text of multiple cells
    By Uncle O in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  3. [SOLVED] combine text of multiple cells
    By Roger Govier in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 09:05 AM
  4. combine text of multiple cells
    By Roger Govier in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 06:05 AM
  5. combine text of multiple cells
    By Uncle O in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

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