Results 1 to 16 of 16
  1. #1
    Crazy like a fox suzigeek's Avatar
    Join Date
    January 18th, 2005
    Posts
    1,096
    Does anyone have simple way to merge 2 columns in excel?? I've looked online and all the explainations I've tried just don't work. I have no problem with 2 cells but I want to merge 2 whole columns...ugh I thought I knew my way around excel doh!!!
    Suz~~GearGirl~~

  2. #2
    Member
    Join Date
    January 18th, 2005
    Location
    Hawke's Bay, New Zealand
    Posts
    91
    Merge... or just create a merged column?

    If you have content in cells A1 and B1 and want to merge that into C1:

    =A1&b1

    If you want to put a space or other content between the data from the two cells, you could do:

    =a1&" "&b1

  3. #3
    Crazy like a fox suzigeek's Avatar
    Join Date
    January 18th, 2005
    Posts
    1,096
    Thanks--Yes I know how add 2 cells together into a third cell.

    I want to merge two columns with 1000 cells/rows of unique data together--it can be in a third column or simply merge two columns together making one column with the data in each cell/row combined--??
    Suz~~GearGirl~~

  4. #4
    Member
    Join Date
    January 18th, 2005
    Location
    Hawke's Bay, New Zealand
    Posts
    91
    Ok. I'm confused.

    The formula above uses "&" instead of "+", so it doesn't add the two columns together like a math formula - it merges the data.

    a1 cats

    b1 dogs

    c1 =a1&"and"&b1 results in 'cats and dogs'

    Is that not what you want to do?

  5. #5
    http and a telephoto
    Join Date
    January 18th, 2005
    Location
    NYC
    Posts
    17,708
    You have to create the formula and drag it, you can't just merge two columns.
    Deborah Carney
    TeamLoxly.com BookGoodies.com ABCsPlus.com

  6. #6
    Crazy like a fox suzigeek's Avatar
    Join Date
    January 18th, 2005
    Posts
    1,096
    Sorry using add was not the right term. Yes merging to columns not just 2 cells together thats what I want to do.

    I understand how to do 2 cells...but I want to do it to the whole column so its something like:
    =a1-a1000&"<br>"&b1-b1000
    or
    =column A & column B
    I just can't figure out how to carry the equation all the way through the columns

    Loxley

    you posted while I was typing--Any hints about dragging I tried that a couple of different ways and it wouldn't plug in the values. I'm going back to excel to try again...wish me luck...Thanks all!
    Suz~~GearGirl~~

  7. #7
    http and a telephoto
    Join Date
    January 18th, 2005
    Location
    NYC
    Posts
    17,708
    I do it all the time, I create the formula and drag it down the column.

    +a1&b1

    Make sure you have the plus sign first. Drag it to a couple of cells to make sure it works.

    Then I hightlight the column, and copy and paste special, as values, to a new column.
    Deborah Carney
    TeamLoxly.com BookGoodies.com ABCsPlus.com

  8. #8
    Crazy like a fox suzigeek's Avatar
    Join Date
    January 18th, 2005
    Posts
    1,096
    OMG I finally did it....it's always the "little " things that tweak you/me. I wasn't dragging correctly waiting for the box thingy to change and grabbing the corner. What ever. I did it life is good again...for the next few hours at least hehe

    Thanks Loxly et al
    Suz~~GearGirl~~

  9. #9
    Member
    Join Date
    January 18th, 2005
    Location
    Hawke's Bay, New Zealand
    Posts
    91
    ah, ok. I think I see now.

    That sounds like the sort of thing I usually cheat with and take it out to word - paste a column as a table, then convert the table to text. Then you can copy the text block back into a single cell in Excel.

    it's dirty, but it works.

  10. #10
    ABW Ambassador
    Join Date
    January 18th, 2005
    Posts
    1,350
    Thank you all so much!

    I've been wracking my brain trying to figure this out.

    Lily

  11. #11
    Full Member
    Join Date
    January 18th, 2005
    Location
    Des Moines, IA
    Posts
    298
    Another way to combine columns A and B is to put the following in cell C1

    =CONCATENATE(A1," ",B1)

    and then drag/copy it down column C. I think the concatenate function treats the contents of the cells as text. Anyway, it works for me.

    Ray

  12. #12
    http and a telephoto
    Join Date
    January 18th, 2005
    Location
    NYC
    Posts
    17,708
    That is what the & accomplishes also....
    Deborah Carney
    TeamLoxly.com BookGoodies.com ABCsPlus.com

  13. #13
    Super Sh!t Stirrer SSanf's Avatar
    Join Date
    January 18th, 2005
    Posts
    9,944
    I want to concatenate cells a1 thru cells e30823 Do I do this in a new column f? Is there a formula I place in cell f1? What would the formula look like? Guess which feed this is, LOL!

    In other words, I want to concatenate columns a, b, c, d, and e. I would place the results in column f.


    Can someone just write the simple formula I can drag down column f for me? I will be able to figure it out myself after that.

    Never mind!

    +a1&b1&c1&d1&e1
    Comments are opinion unless otherwise noted. Remember, pillage first. Then burn. Half of all people in the world have IQs under 100. You best learn to trust ol' SSanf!

  14. #14
    The Eternal Optimist zimmy's Avatar
    Join Date
    January 18th, 2005
    Location
    NC
    Posts
    696
    Start with row 1 and put this formula in new column f: =CONCATENATE(A2,B2,C2,D2,E2)

    Now you want to copy the results of column f, row 1 and paste it into all of the other rows in column f.

    Hope that helps.



    ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*

    The big shots are only the little shots who keep shooting.
    -Christopher Morley

  15. #15
    Super Sh!t Stirrer SSanf's Avatar
    Join Date
    January 18th, 2005
    Posts
    9,944
    Zimmy, Thanks! Look above! Life is good!
    Comments are opinion unless otherwise noted. Remember, pillage first. Then burn. Half of all people in the world have IQs under 100. You best learn to trust ol' SSanf!

  16. #16
    The Eternal Optimist zimmy's Avatar
    Join Date
    January 18th, 2005
    Location
    NC
    Posts
    696
    Good deal - you beat me to it! That's the best way!



    ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*

    The big shots are only the little shots who keep shooting.
    -Christopher Morley

  17. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Merging Column data in Excel
    By bkotamballi in forum Programming / Datafeeds / Tools
    Replies: 3
    Last Post: January 2nd, 2008, 11:23 PM
  2. Merging accounts
    By PatrickAllmond in forum Search Engine Optimization
    Replies: 3
    Last Post: September 27th, 2006, 11:08 PM
  3. aligning columns in excel
    By epicadventures in forum Programming / Datafeeds / Tools
    Replies: 8
    Last Post: August 9th, 2004, 07:10 AM
  4. Merging Word Documents
    By kenmerge in forum WebMerge (Fourthworld.com)
    Replies: 6
    Last Post: May 24th, 2004, 04:42 PM
  5. Handspring merging with Palm
    By ronwls in forum Rakuten LinkShare - LS
    Replies: 5
    Last Post: November 29th, 2003, 08:36 AM

Posting Permissions

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