merge cell
 

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

merge cell
 

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)?

merge cell
 

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)?

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)?

merge cell
 

Itried this formula, and I'm getting this (39521 ,2008). Thanks


"Marcelo" wrote:

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)?

merge cell
 

That indicates that the Mar. 14 is already in date format. Just format that
cell with one of the date formats that includes year.
--
TedMi

"ga1260" wrote:

Itried this formula, and I'm getting this (39521 ,2008). Thanks

merge cell
 

10-Oct 1989 39731, 1989

I tried the format like you said but this is what I'm getting. Thanks


"tedmi" wrote:

That indicates that the Mar. 14 is already in date format. Just format that
cell with one of the date formats that includes year.
--
TedMi

"ga1260" wrote:

Itried this formula, and I'm getting this (39521 ,2008). Thanks