M Mike H Oct 16, 2008 #2 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
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
G ga1260 Oct 16, 2008 #3 I have one column for march 14 and another column for the year 2006, how can i merge those two columns together?
I have one column for march 14 and another column for the year 2006, how can i merge those two columns together?
M Marcelo Oct 16, 2008 #4 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:
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:
T tedmi Oct 16, 2008 #6 That indicates that the Mar. 14 is already in date format. Just format that cell with one of the date formats that includes year.
That indicates that the Mar. 14 is already in date format. Just format that cell with one of the date formats that includes year.
G ga1260 Oct 16, 2008 #7 10-Oct 1989 39731, 1989 I tried the format like you said but this is what I'm getting. Thanks
