Does some have a real answer to this, please

"Gary''s Student" wrote:

> 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?