+ Reply to Thread
Results 1 to 3 of 3

How to concatenate dynamic list in one cell?

  1. #1
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,762

    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

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,359

    Re: How to concatenate dynamic list in one cell?

    http://www.excelforum.com/showthread.php?t=1172627

  3. #3
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar but I could be everywhere
    MS-Off Ver
    All on PC except 365
    Posts
    10,013

    Re: How to concatenate dynamic list in one cell?

    [deleted by author]
    Last edited by sandy666; 02-06-2017 at 05:54 AM.
    sandy
    I want to see what you are trying to achieve, not how you are trying to do it
    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

+ 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. 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. Replies: 2
    Last Post: 04-12-2010, 12:35 PM
  6. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1