+ Reply to Thread
Results 1 to 2 of 2

Column contents to continuous text

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

    Column contents 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

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,412

    Re: Column contents to continuous text

    Put this formula in A1:

    =B1

    and this one in B2:

    =B1&","&A2

    Then copy this down to the bottom of your data (double-click the fill handle with B2 selected). The result you want is in the bottom cell of column B, or if you want it in , say, C1, use this formula in C1:

    =INDEX(B:B,counta(B:B))

    Hope this helps.

    Pete

+ 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