+ Reply to Thread
Results 1 to 4 of 4

Merge 2 Columns

  1. #1
    Registered User
    Join Date
    05-18-2012
    Location
    North Yorkshire, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    Exclamation Merge 2 Columns

    Hi Guys,

    I am not a legend with Excel to put it bluntly. I have 2 columns (as below), one with our product description and the other with xx SALE PRICE xx to signify that item is on sale. I would like to add these two columns together so i can export them in one column, eg PACK 100 MED PLASTIC TRAD GIFT CARRIER BAG xx SALE PRICE xx

    PACK 1000 MED PLASTIC TRAD GIFT CARRIER BAG xx SALE PRICE xx
    PACK OF 1000 LARGE PLASTIC TRAD CARRIER BAGS xx SALE PRICE xx

    If you can let me know how to do this step by step, i would be very appriciative :-)

    Thanks.

    Julian x

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Merge 2 Columns

    Hi

    You want to combine two columns... right? Try this:

    =concatenate(col1," ",col2)
    Click *, if my suggestion helps you. Have a good day!!

  3. #3
    Registered User
    Join Date
    05-18-2012
    Location
    North Yorkshire, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Merge 2 Columns

    That is fecking Genius, saved me a week, cheers pal.

  4. #4
    Registered User
    Join Date
    06-27-2011
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    55

    Re: Merge 2 Columns

    Actually, you can use =A1&" "&B1 too. Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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