+ Reply to Thread
Results 1 to 4 of 4

Splitting data in a column up into pieces of 20 at a time

  1. #1
    Registered User
    Join Date
    06-28-2011
    Location
    Spain
    MS-Off Ver
    Excel 2003
    Posts
    29

    Splitting data in a column up into pieces of 20 at a time

    Hello,

    I was wondering if anyone could help me with this.

    I have a column with hundreds of rows and what I need to do is take 20 rows at a time and merge them into single strings with a predetermined piece of text added to the beginning.

    I am able, when given a list of rows to concatenate them, but I can not figure out how to do it into blocks of 20 with a predefined text added at the beginning.

    I am using this code to concatenate the rows:

    Please Login or Register  to view this content.
    The last block does not need to have 20 rows in it, just whatever is left before the list runs out (see example in file).

    I have created an example file which I have included which is basically what I am trying to achieve.

    Any help at all would be much appreciated.

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,647

    Re: Splitting data in a column up into pieces of 20 at a time

    Please Login or Register  to view this content.



  3. #3
    Registered User
    Join Date
    06-28-2011
    Location
    Spain
    MS-Off Ver
    Excel 2003
    Posts
    29

    Re: Splitting data in a column up into pieces of 20 at a time

    Thanks! This is what I was trying to do.

  4. #4
    Registered User
    Join Date
    06-28-2011
    Location
    Spain
    MS-Off Ver
    Excel 2003
    Posts
    29

    Re: Splitting data in a column up into pieces of 20 at a time

    Mod: this thread can be marked solved. Thanks.
    Last edited by vzc8; 08-23-2011 at 10:59 AM.

+ 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