I have the date (m/dd/yy) in one cell and time (hh:mm) in another cell. How
can I merge these two in one cell with the format m/dd/yy hh:mm ?

Thanks.

Date in A1, time in B1, combined in C1: formula is =A1+B1 and format as you
describe.

On Sat, 22 Jan 2005 14:03:02 -0800, "Kelly C"
wrote:

I have the date (m/dd/yy) in one cell and time (hh:mm) in another cell. How
can I merge these two in one cell with the format m/dd/yy hh:mm ?

Thanks.

=TEXT(A1,"m/dd/yy ")&TEXT(B1,"hh:mm")

is one way

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Kelly C" wrote in message
...
I have the date (m/dd/yy) in one cell and time (hh:mm) in another cell.
How
can I merge these two in one cell with the format m/dd/yy hh:mm ?

Thanks.

Myrna - I found your solution very helpful! Much better than the combining
text. It maintained the format and I was able to perform other functions on
the result.
Thank you!

"Myrna Larson" wrote:

Date in A1, time in B1, combined in C1: formula is =A1+B1 and format as you
describe.

On Sat, 22 Jan 2005 14:03:02 -0800, "Kelly C"
wrote:

I have the date (m/dd/yy) in one cell and time (hh:mm) in another cell. How
can I merge these two in one cell with the format m/dd/yy hh:mm ?

Thanks.