Try just adding them. Example:

1/12/2005 7:30 AM 1/12/2005 7:30
in cols A,B,C
--
Gary''s Student


"bladelock" wrote:

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?