+ Reply to Thread
Results 1 to 3 of 3

How to concatenate dynamic list in one cell?

  1. 02-06-2017, 05:27 AM #1
    ImranBhatti
    ImranBhatti is offline
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    How to concatenate dynamic list in one cell?

    Hello

    In column A I have Item names which may increase or decrease

    In cell C2 I want to concatenate those items separated by ;

    EXAMPLE:
    Column A
    Sugar
    Tea
    Oil
    toothpaste
    biscuits

    and so on

    Cell C3

    Sugar;Tea;Oil;toothpaste;biscuits

    Best Regards

    Irman Bhatti
    Teach me Excel VBA
    Reply With QuoteRegister To Reply
  2. 02-06-2017, 05:33 AM #2
    tim201110
    tim201110 is offline
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: How to concatenate dynamic list in one cell?

    http://www.excelforum.com/showthread.php?t=1172627
    Reply With QuoteRegister To Reply
  3. 02-06-2017, 05:48 AM #3
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: How to concatenate dynamic list in one cell?

    [deleted by author]
    Last edited by sandy666; 02-06-2017 at 05:54 AM.
    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. Dynamic Concatenate based on varying cell address references
    By sambusby in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-28-2015, 08:55 PM
  2. Dynamic Concatenate based on varying cell address references
    By sambusby in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-28-2015, 08:29 PM
  3. [SOLVED] Concatenate list of dates into one cell without duplicates
    By rachel.dudley in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-14-2013, 07:38 AM
  4. [SOLVED] List of Email Addresses that I need to Concatenate into one cell
    By amyp22x3 in forum Excel General
    Replies: 3
    Last Post: 01-17-2013, 03:42 PM
  5. How to concatenate a dynamic list of cells but only concatenate unique entries
    By Philster in forum Excel General
    Replies: 2
    Last Post: 04-12-2010, 12:35 PM
  6. Can I take text from a dynamic range and concatenate into a single cell?
    By woodfield in forum Excel General
    Replies: 1
    Last Post: 06-16-2009, 09:42 AM
  7. reference to a dynamic cell in a list?!
    By rjmills18 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-16-2008, 09:13 AM

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