G
ga1260
How do I merge 2 cell (date and year)?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
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
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
G
ga1260
I have one column for march 14 and another column for the year 2006, how can
i merge those two columns together?
i merge those two columns together?
M
Marcelo
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:
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:
G
ga1260
Itried this formula, and I'm getting this (39521 ,2008). Thanks
T
tedmi
That indicates that the Mar. 14 is already in date format. Just format that
cell with one of the date formats that includes year.
cell with one of the date formats that includes year.
G
ga1260
10-Oct 1989 39731, 1989
I tried the format like you said but this is what I'm getting. Thanks
I tried the format like you said but this is what I'm getting. Thanks