Page 1 of 2 12 LastLast
Results 1 to 10 of 13

How do I merge 2 columns into one?

This is a discussion on How do I merge 2 columns into one? within the Excel Questions forums, part of the Question Forums category; sf...

  1. #1
    New Member
    Join Date
    Sep 2003
    Posts
    12

    Default How do I merge 2 columns into one?

    sf

  2. #2
    New Member
    Join Date
    Jan 2004
    Posts
    4

    Default Re: How do I merge 2 columns into one?

    Hi,

    Just use the & character to merge fields.

    If A1 contains "Hello" and B1 contains "Bob"

    in C1 type =A1&" "&B1

    You would get Hello Bob.

    This works with numbers as well.

  3. #3
    New Member
    Join Date
    Sep 2003
    Posts
    12

    Default Re: How do I merge 2 columns into one?

    But I need to merge multiple cells at once

  4. #4
    Board Regular
    Join Date
    Nov 2003
    Location
    South Jersey
    Posts
    112

    Default Re: How do I merge 2 columns into one?

    use the concatenate function

    =concatenate(A1,B1,C1)

    where A1, B1, C1 are the cells you want to combine.

  5. #5
    Board Regular Iridium's Avatar
    Join Date
    Jul 2002
    Location
    West Bridgford, Notts., England
    Posts
    2,834

    Default Re: How do I merge 2 columns into one?

    Concatenation via macro:

    Code:
    Sub ConcatenateColumns()
    'Click the top cell in the right-hand column of data that you want to concatenate. _
    For example, if cells A1:A100 and B1:B100 contain data, click cell B1.
    
       Do While ActiveCell <> ""  'Loops until the active cell is blank.
    
          'The "&" must have a space on both sides or it will be
          'treated as a variable type of long integer.
    
          ActiveCell.Offset(0, 1).FormulaR1C1 = _
             ActiveCell.Offset(0, -1) & " " & ActiveCell.Offset(0, 0)
    
          ActiveCell.Offset(1, 0).Select
       Loop
    
    End Sub
    Another idea....

    HTH
    Iridium


  6. #6
    New Member
    Join Date
    Aug 2009
    Posts
    1

    Default Re: How do I merge 2 columns into one?

    ^ Seems pretty useful! Thanks for sharing your thoughts~

  7. #7
    Board Regular
    Join Date
    Oct 2011
    Location
    Temecula, CA
    Posts
    52

    Default Re: How do I merge 2 columns into one?

    Hello,

    I tried this =CONCATENATE(B1:B466) in Excel 2010 and all it returned was B1. Any ideas? Thank you.

    JT

  8. #8
    New Member
    Join Date
    Apr 2012
    Posts
    2

    Default Re: How do I merge 2 columns into one?

    How do I merge the two columns below:

    Column A:

    23/04/2012
    23/04/2012
    23/04/2012
    23/04/2012
    23/04/2012
    23/04/2012
    23/04/2012
    23/04/2012
    23/04/2012

    and Column B:

    17:37
    20:35
    18:55
    20:41
    21:14
    15:04
    15:05
    15:39
    15:54

    I tried the merge cells, It did not work.

  9. #9
    VoG
    VoG is offline
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,565

    Default Re: How do I merge 2 columns into one?

    Try in a spare column

    =A1+B1

    and copy down. Format as Custom dd/mm/yyyy hh:mm
    HTH, Peter
    Please test any code on a copy of your workbook.

  10. #10
    New Member
    Join Date
    Jul 2010
    Posts
    18

    Default Re: How do I merge 2 columns into one?

    You may also have to insert a space between the two strings if Excel thinks either of the cells is text instead of number: A1 &" "& B1

Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com