Thread: merge cell
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default merge cell

Hello,

assuming we have text here (if was date the year shoub be with march 14, and
the solution shoud format).

march 14 is on B2
2006 is in C2

use in D2 =B2&" ,"&C2.


hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"ga1260" escreveu:

I have one column for march 14 and another column for the year 2006, how can
i merge those two columns together?

"Mike H" wrote:

Hi,

This isn't clear what is in the 2 cells you want to merge (concatenate?) and
what do you expect to see in the concatenated cell?

Mike

"ga1260" wrote:

How do I merge 2 cell (date and year)?