+ Reply to Thread
Results 1 to 3 of 3

column entries to continuous text

  1. #1
    Registered User
    Join Date
    09-17-2012
    Location
    Wiltshire
    MS-Off Ver
    Excel 2003
    Posts
    22

    column entries to continuous text

    Hi all
    I have exported data from sql into a csv file, i have then text to columns the information. Now what i need to do is get Column A contents into a continuous line of text with a comma inbetween.
    e.g
    column A
    123456
    123457
    123458

    want this to be turned into
    123456,123457,123458

    however this can be done is fine function script or anything would be much appreciated
    Last edited by Firemaster; 10-16-2012 at 08:29 AM.

  2. #2
    Forum Contributor
    Join Date
    10-02-2012
    Location
    Bumi Nusantara
    MS-Off Ver
    Excel 2010; Excel 2016
    Posts
    136

    Re: column entries to continuous text

    in b1
    Please Login or Register  to view this content.
    in b2
    Please Login or Register  to view this content.
    copied down
    click the star if it solves your problem

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,043

    Re: column entries to continuous text

    Look here: http://www.excelforum.com/excel-form...=1#post2970184
    Never use Merged Cells 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