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!

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!

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!

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!