| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
merge cell
How do I merge 2 cell (date and year)?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Merge, didn't... | Excel Discussion (Misc queries) | |||
| how to merge many cell to one cell with keeping all data | Excel Worksheet Functions | |||
| How to merge one cell from many workbooks to one cell on one work | Excel Worksheet Functions | |||
| Merge cell & Copy Data from different cell | Excel Discussion (Misc queries) | |||
| How do I merge 2 cells for ex. DE (1 cell) & 01234 (2 cell) into . | Excel Discussion (Misc queries) | |||
Hybrid Mode
