+ Reply to Thread
Results 1 to 6 of 6

VBA help - concatenate column data to 1 cell with separator

  1. 02-07-2018, 07:03 PM #1
    Troy3977
    Troy3977 is offline
    Registered User
    Join Date
    02-07-2018
    Location
    Jacksonville, FL
    MS-Off Ver
    2013
    Posts
    3

    VBA help - concatenate column data to 1 cell with separator

    I'm brand new to these forums and VBA and am looking forward to expanding my knowledge. However, I'm in need of a solution rather quickly. I'm trying to concatenate data in column C (varying in length) to a single cell, I5, separated by ";". Any help would be greatly appreciated!

    data.JPG

    Thank you,

    Troy Alexander
    Reply With QuoteRegister To Reply
  2. 02-07-2018, 07:18 PM #2
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: VBA help - concatenate column data to 1 cell with separator

    Try this UDF
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here
    Reply With QuoteRegister To Reply
  3. 02-07-2018, 07:31 PM #3
    Troy3977
    Troy3977 is offline
    Registered User
    Join Date
    02-07-2018
    Location
    Jacksonville, FL
    MS-Off Ver
    2013
    Posts
    3

    Re: VBA help - concatenate column data to 1 cell with separator

    Sorry - Exactly what in the UDF above do I need to modify to fit my data set? Thanks so much for the quick reply and your help!
    Reply With QuoteRegister To Reply
  4. 02-07-2018, 07:33 PM #4
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: VBA help - concatenate column data to 1 cell with separator

    You can use it and put a formula like that in cell I5
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 02-07-2018, 07:44 PM #5
    Troy3977
    Troy3977 is offline
    Registered User
    Join Date
    02-07-2018
    Location
    Jacksonville, FL
    MS-Off Ver
    2013
    Posts
    3

    Re: VBA help - concatenate column data to 1 cell with separator

    Brilliant - Thanks so much, YasserKhalil!
    Reply With QuoteRegister To Reply
  6. 02-07-2018, 07:49 PM #6
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: VBA help - concatenate column data to 1 cell with separator

    You're welcome. Glad I can offer some help
    Please mark the thread as solved

    Regards
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Combine data in cell withn Comma Separator
    By Parth007 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-04-2016, 09:31 PM
  2. UDF - Concatenate Many Cells into 1 cell that includes paragraph breaks and a separator
    By Mitchslap in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2014, 02:54 PM
  3. How to concatenate email addresses from different rows into 1 line with comma separator
    By ohlalayeah in forum Excel General
    Replies: 8
    Last Post: 01-17-2013, 09:26 AM
  4. macro to concatenate data from column into a single cell
    By Poonjas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-23-2012, 04:29 AM
  5. [SOLVED] Summing values in same cell with separator with values without separator
    By akreda in forum Excel General
    Replies: 4
    Last Post: 07-04-2012, 03:41 PM
  6. [SOLVED] Help Concatenate All Cells In A Column To A Single Cell In Another Column
    By imnickb in forum Excel General
    Replies: 8
    Last Post: 06-19-2012, 02:32 PM
  7. [SOLVED] Splitting Data in a cell, left or right of a separator.
    By ross in forum Excel General
    Replies: 1
    Last Post: 08-11-2005, 10:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1