+ Reply to Thread
Results 1 to 3 of 3

How to convert list to one cell with commas?

  1. #1
    Registered User
    Join Date
    04-08-2009
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    85

    How to convert list to one cell with commas?

    I've got a list of codes in one column, such as ABC, XYZ etc which I want to put into one cell
    separated by commas - any ideas how to do this please? (Using Excel 2003 and Word 2003)

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,842

    Re: How to convert list to one cell with commas?

    You can go about this two ways that I can see (there may be more):

    Method 1 - Assuming your data starts in A1 and goes down, in cell B2, enter this formula:
    =A1&", "&A2

    Then in cell B3 enter this formula and fill down to the end of the list:
    =B2&", "&A3

    The final cell in column B will have your list separated by commas.

    Method 2 - Use the following information to implement the ConcRange UDF thru VBA (very simple to use - even I could do it!):
    http://www.vbaexpress.com/kb/getarticle.php?kb_id=817

    - Moo

  3. #3
    Registered User
    Join Date
    04-08-2009
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    85

    Re: How to convert list to one cell with commas?

    Thanks Moo, Method 1 did the trick!

+ 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. Convert Excel Column to text file seperated by commas
    By stri9504 in forum Excel General
    Replies: 9
    Last Post: 05-17-2015, 02:34 PM
  2. Replies: 5
    Last Post: 01-17-2014, 05:56 PM
  3. Convert to CSV , extra commas displaying
    By yashu in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-24-2013, 08:49 PM
  4. Replies: 5
    Last Post: 06-05-2012, 03:32 PM
  5. Replies: 2
    Last Post: 05-26-2010, 03:56 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