+ Reply to Thread
Results 1 to 4 of 4

Combine multiple cells in columns - Concat with variable spacing using VBA Script

  1. #1
    Registered User
    Join Date
    11-12-2013
    Location
    Denver
    MS-Off Ver
    Latest 365 Build 16.0
    Posts
    4

    Combine multiple cells in columns - Concat with variable spacing using VBA Script

    I have seen multiple threads on this subject but most are more complex than I need.

    Basically I just want to combine the data from selected column (e.g. Col A) and concat that with data in target column (e.g. Col B) however I want to specify the number of imbedded spaces between the two values (e.g. 30 blanks).

    Col A...............................Col B (before)b.................................Col B (after)
    A1001............................SERVER COMPUTER...................SERVER COMPUTER.................A1001
    A1022.............................SWITCH 24 PORTS...................SWITCH 24 PORTS.................A1022
    A1038.............................SWITCH ROUTER......................SWITCH ROUTER...................A1038

    I would be preferable if I can select blocks of rows in Source Column to concat same in target column. Thanks in Advance!

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Combine multiple cells in columns - Concat with variable spacing using VBA Script

    Do you mean this?:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    11-12-2013
    Location
    Denver
    MS-Off Ver
    Latest 365 Build 16.0
    Posts
    4

    Re: Combine multiple cells in columns - Concat with variable spacing using VBA Script

    yes that is it... can you modify it to make the Target column variable (promptable at run time) + instead of fixed padding after the value to concat starting a given position (e.g. 100) and only to work for the active sheet.

    Thanks for your help!
    Last edited by AMC_CO; 11-13-2013 at 12:23 PM.

  4. #4
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Combine multiple cells in columns - Concat with variable spacing using VBA Script

    can you modify it to make the Target column variable (promptable at run time) + instead of fixed padding after the value to concat starting a given position (e.g. 100) and only to work for the active sheet.
    I'm sorry but I have no idea what that means.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need macro to split one column into multiple columns based on _ and spacing
    By snely in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 09-17-2012, 10:05 AM
  2. Combine cells but one variable remain constant
    By balexander26 in forum Excel General
    Replies: 3
    Last Post: 11-10-2011, 03:23 AM
  3. Spacing multiple variable paragraphs in a merged cell
    By shotputjuggler in forum Excel General
    Replies: 4
    Last Post: 06-20-2009, 03:55 AM
  4. Macro to combine variable multiple rows
    By Help? in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-10-2006, 12:10 PM
  5. Replies: 0
    Last Post: 07-31-2006, 12:13 PM

Tags for this Thread

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