+ Reply to Thread
Results 1 to 3 of 3

How do I combine multiple lines of information into a single cell, separated by commas?

  1. #1
    Registered User
    Join Date
    11-21-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    2

    How do I combine multiple lines of information into a single cell, separated by commas?

    Hi. I'm pretty new to advanced Excel functions, hopefully someone here can help me out.

    I have a list of names in column A and I would like to combine them into a single cell with the names separated by commas. I've attached my worksheet. This one only has 366 names but the one I will be working on next will have a couple thousand I would like to avoid naming each individual cell manually if possible. If someone has a shortcut that would be awesome.

    Thanks!

    Copy of schoolboard full.xlsx

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: How do I combine multiple lines of information into a single cell, separated by commas

    You could put this formula in B2:

    =A1&","&A2

    And put this in B3 and copy down.

    =B2&","&A3

    Or you could run this code.
    Please Login or Register  to view this content.
    Got to ask though, why do you want this list?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    11-21-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: How do I combine multiple lines of information into a single cell, separated by commas

    That worked perfectly, thanks so much!!!

    I pulled this list from our database which exported a long document with lots of columns(which is why it is set up like this to begin with). I'm creating a form and I need to have a drop down option where people select which school board they belong to. The generator that I'm using to create the form only accepts values separated by commas. Next I need to create a drop down for every school in the country! You've saved me a ton of time, I knew there had to be an easier way to do this in Excel.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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