Results 1 to 8 of 8

Thread: VBA - Concatenate columns with delimiter

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    VBA - Concatenate columns with delimiter

    Hello everybody!

    I have a question for a VBA code, and as a complete beginner in the world of VBA, I have no idea where to start.

    My goal is to concatenate some columns, the number will vary, with the delimiter " > " - no quotes, in the first cell of the row.
    I will be doing this for an unknown number of rows down, often several hundreds or thousands.

    Below are two pictures of the idea, the first showing the concept. I have a set of columns, and these need to be combined in the first cell of each row, in this case the empty A-rows.

    1.JPG

    The result should be like this, with all columns combined, separated by the delimiter >.
    2.JPG

    Hope somebody can help
    Last edited by Sinsation; 06-23-2022 at 02:59 AM. Reason: Solved

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •