Results 1 to 13 of 13

Formula that combines text cells into single cell paragraph

Threaded View

  1. #1
    Registered User
    Join Date
    08-02-2012
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2003
    Posts
    9

    Formula that combines text cells into single cell paragraph

    I have a spreadsheet that compiled Employer of Choice data for several companies, with each company on a separate tab. Under category headers, we listed several components for each company that we found, i.e.: Childcare,Telecommuting, Free transportation, etc.

    I'm pulling this data into Tableau (an infographic program) and would now like the lists to combine into one paragraph, separated by semicolons, that will show on the tooltip mouse-over. For example:

    Childcare
    Telecommuting
    Free transportation

    ...would show as:

    Childcare; Telecommuting; Free transportation

    The problem is, some of these lists have 12 things, some have 3. I've tried to write formulas like IF(COUNTA(B17:B28)=6, B17&"; "&B18.... etc. that count down, but these have too many IF arguments. I don't want things that have only 3 items to end with "; ; ; "

    Can someone please help?! I know there is a character limit for cells, so I've tried to write "and more" into the formula if it's greater than 6, but these are still too many if statements.

    Attached is an example of one company tab.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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