Results 1 to 9 of 9

Is there a way to combine text from multiple cells into one cell with a comma b/t?

Threaded View

  1. #1
    Registered User
    Join Date
    12-05-2014
    Location
    KCMO
    MS-Off Ver
    2010
    Posts
    9

    Is there a way to combine text from multiple cells into one cell with a comma b/t?

    Hi All,

    Is there a formula or function in excel that would allow me to combine text from several cells into one cell with a comma in between the text?

    So cell B2 says "He does well" and C2 says "Strong worker" and D2 says nothing, and E2 says "Doing Okay"

    I would like that combined into A2 to look like this - "He does well, Strong worker, Doing Okay"

    I believe I can do this "=B2&", "&C2" but I how do I do it for more cells? Also is there a way to ignore blank cells so there won't be a blank comma?

    Please let me know. You all have been great so far. Thanks!!!!!!
    Last edited by theresabirdoutthere; 12-05-2014 at 05:57 PM.

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. Search cell for multiple text , return comma separated text in separate cell if found
    By dangerdoug in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-01-2013, 01:52 PM
  3. [SOLVED] Copy text from multiple cells and combine to one cell
    By villman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2012, 12:01 AM
  4. Replies: 2
    Last Post: 12-03-2011, 03:51 AM
  5. Replies: 3
    Last Post: 04-27-2011, 12:59 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