How can I combine two columns to one new column
Example: (i'm trying to find "C")

A B C
[Date] [Time] [Both]
01/01/2005 14:45:00 01/01/2005 14:45:00

I need column "C" to be a format as mm/dd/yyy hh:mm:ss

I tried Concatenaing("A1", "B1") but I get a bunch of numbers

can anyone help?