how do you merge two columns in excel

[JE McGimpsey]

You can use a helper column:

C1: =A1 & B1

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

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



"SheE" <[email protected]> wrote:

 

[Springbok]

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