How do I merge two cells but keeping all contents in Excell?

[gysl]

I would like to merge two cells without losing the data ea: Column A= AB and
Column B = 1234. End result want to achieve Column C = AB1234 Please help -
Gys

 

[Anne Troy]

In column C: =A2&B2
(for row 2)
This is a "short version" of concatenation, you can look up the CONCATENATE
function, which I never use because I use the & method instead.
************
Anne Troy
www.OfficeArticles.com

 

[gysl]

Thank you very much. Good day Gys

In column C: =A2&B2
(for row 2)
This is a "short version" of concatenation, you can look up the CONCATENATE
function, which I never use because I use the & method instead.
************
Anne Troy
www.OfficeArticles.com