View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default How do I merge two cells but keeping all contents in Excell?

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