+ Reply to Thread
Results 1 to 2 of 2

merge column of data with comma separators to one cell

  1. 08-22-2013, 08:59 PM #1
    tamlh
    tamlh is offline
    Registered User
    Join Date
    08-19-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    1

    Question merge column of data with comma separators to one cell

    I am new to VBA, I would like to join column data into one cell using commas between the values. also, my data contains some blank cells.
    does anyone know the VBA code?
    Reply With QuoteRegister To Reply
  2. 08-22-2013, 09:29 PM #2
    ajryan88
    ajryan88 is offline
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: merge column of data with comma separators to one cell

    Hi,

    Try this. Is it what you are looking for?
    Attached Files Attached Files
    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] separate cell with comma separated data into one column
    By Tenos in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-12-2012, 02:45 PM
  2. Creating New Column from Cell - Data After Last Comma
    By Ohnomycocoa in forum Excel General
    Replies: 0
    Last Post: 10-05-2011, 06:13 AM
  3. Excel 2011 - comma separators instead of periods
    By Sugarshakersar in forum Excel General
    Replies: 1
    Last Post: 06-07-2011, 12:11 AM
  4. merge contents of a row of data into one cell separated by a comma
    By nicko54 in forum Excel General
    Replies: 8
    Last Post: 01-29-2010, 09:31 AM
  5. [SOLVED] merge text from a column into on cell seperated by comma's
    By Craig in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-18-2005, 06:50 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