how do you merge two columns in excel
 

I need to merge two columns together. How do I do this?

Hi

depends a bit on what you really mean - some options:
- where you want two adjacent cells to physically become 1 cell - select
the cells, choose format / cells / merge cells ... note, merged cells can
cause problems with sorting & filtering
- where you have information in two cells and you want to put both pieces of
information together in a third cell - ie you have
.......A..........B..............C
1...John......Smith......
in C1 you want John Smith

you can do this using
=A1 & " " & B1
or
=CONCATENATE(A1," ",B1)

Hope this helps
Cheers
JulieD


"SheE" wrote in message
...
I need to merge two columns together. How do I do this?