=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.