Results 1 to 10 of 10

Combining Value of A Column to 1 Cell

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-02-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    353

    Combining Value of A Column to 1 Cell

    Hello,
    How do I go about this on excel:

    Assuming I have a list of Data on Column A
    Example:

    ABCD123
    CEFG456
    RRR111
    FFF222
    CCCDDD
    and so on..

    Then on Column B1, the output will be joined and seperated by a Semi colon? So it look like this.
    ABCD123;CEFG456;RRR111;FFF222;CCCDDD;

    Please note that the number of records on column A will vary, at times a lot, at time a few.
    Hope you could help how to make a formula for this, thanks.
    Last edited by Andrew.Trevayne; 12-28-2010 at 12:29 AM.

Thread Information

Users Browsing this Thread

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

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