EXCEL: Merge to cells into one 2

[Ammodog]

Can anyone tell me how to merge to cells into one so that for example I have one cell "C" and another "K9DW" I want to bring them together to "ck9dw" Thank You

Christopher Abney
"There is no limit to the good you can do if you dont care who gets the credit"
[Afro2]

 

[fneily]

Let's say A1 has C, B1 has K9DW. In cell C1, put =CONCATENATE(A1,B1)

Neil

 

[carrr]

If "c" is in A1 and "k9dw" is in B1,then =CONCATENATE(A1,B1)
gets you "ck9dw" in whatever cell you apply the formula

 

[carrr]

fneily moves first, shoots, .... and scores!

 

[fneily]

Nah, Carr was just facing the other basket. OT.

 

[WildeWebPublishing]

Or another way is write this formula in c1
=a1&b1 giving you "ck9dw"