| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Way to merge data in 3 cells?
Hello,
I have a raw data with the month in cell A1, Day in B1 and Year in D1. How do I put them in one cell so it will read (month-Day-Year)? Thanks Cameron *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Way to merge data in 3 cells?
Hi,
you could paste: =DATE(D1,A1,B1) in a different cell (e.g., A2) then goto Format - Cells - click Number tab - choose Custom and paste the following under "Type:": (m-d-yyyy) "Cam Hua" wrote in message ... Hello, I have a raw data with the month in cell A1, Day in B1 and Year in D1. How do I put them in one cell so it will read (month-Day-Year)? Thanks Cameron *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Way to merge data in 3 cells?
Cam Hua,
If you want to use Excel to format the date through the number format: =DATE(D1,A1,B1) If you want the result to be text: =A1&"-"&B1&"-"&D1 Dale Preuss "Cam Hua" wrote: Hello, I have a raw data with the month in cell A1, Day in B1 and Year in D1. How do I put them in one cell so it will read (month-Day-Year)? Thanks Cameron *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Way to merge data in 3 cells?
=Date(D1,A1,B1)
format cell as mm-dd-yyyy -- Regards, Tom Ogilvy "Cam Hua" wrote in message ... Hello, I have a raw data with the month in cell A1, Day in B1 and Year in D1. How do I put them in one cell so it will read (month-Day-Year)? Thanks Cameron *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it is possible to merge data from 2 cells into one? | New Users to Excel | |||
| Merge cells with same data | Excel Discussion (Misc queries) | |||
| Merge Two Cells and Keep all Data | Excel Discussion (Misc queries) | |||
| merge cells that contain the same data | Excel Discussion (Misc queries) | |||
| Merge data from different cells | Excel Discussion (Misc queries) | |||
Linear Mode
