Hi, I have imported some data into excel from a text file.

Column1: date (mm:dd:yy)
column2 : time eg 1500 (24 hour time, however only imported a string)

What I need to do is combone these two columns into a single column that
consists of date & time.
eg 03/15/2003 3:00:00 PM

Is this possible?

Thank you.