how do you merge two columns in excel
 

You can use a helper column:

C1: =A1 & B1

copying down as far as necessary. To do it in place, take a look he

http://www.mcgimpsey.com/excel/subs/mergedata.html



In article ,
"SheE" wrote:

Hi,

I'm assuming you mean concatenate?

Example: A1 = Jon ; A2 = Springbok

=CONCATENATE(A1," ",A2)
Result: Jon Springbok

Is that what your looking for?

Cheers,
Jon

"SheE" wrote: