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

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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
> news:[email protected]...
> >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
>
>
>