+ Reply to Thread
Results 1 to 2 of 2

enumerating in one column with cell values in 2 columns

  1. #1
    Registered User
    Join Date
    03-09-2012
    Location
    china
    MS-Off Ver
    Excel 2007
    Posts
    16

    enumerating in one column with cell values in 2 columns

    hello..
    there are data in A,B column.

    I want to make formula union in C column

    target cell will becell union.xlsx formula in attached file is yellow cell.

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: enumerating in one column with cell values in 2 columns

    the formula in C2 could be:
    Please Login or Register  to view this content.
    You may add any characters between values of the cells by adding another concatenation "&" as in:
    Please Login or Register  to view this content.
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

+ 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. [SOLVED] Compare 4 column values then insert a 5th columns value to a blank column/cell value
    By JasonKMcCoy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-27-2012, 06:01 PM
  2. Replies: 2
    Last Post: 08-22-2012, 04:24 PM
  3. Macro to hide columns based on cell values in the column to be hidden
    By JCMus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2012, 06:06 PM
  4. Matching the cell values in a column to multiple columns
    By shrimic in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-14-2012, 01:58 PM
  5. Column cells enumerating
    By CESAR V. ARROYO in forum Access Programming / VBA / Macros
    Replies: 5
    Last Post: 07-19-2009, 01:44 PM

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