merging columns in excel

1. 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!!!

2. 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. 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--??

4. 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. You have to create the formula and drag it, you can't just merge two columns.

6. 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&"&lt;br&gt;"&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!

7. 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.

8. 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

9. 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. Thank you all so much!

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

Lily

11. 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. That is what the & accomplishes also....

13. 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

14. 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.

15. Zimmy, Thanks! Look above! Life is good!

16. Good deal - you beat me to it! That's the best way!