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

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" wrote in message
...
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

Thank you very much. Good day Gys

"Anne Troy" wrote:

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" wrote in message
...
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