combine cells date time
Does anyone know how to combine dates and times that are in two different
columns into one column!? I know that dates and times are really just a
series of numbers and when I use the CONCATENATE function it does add those
values together but I'm stumped as to how to get the column to show the date
and time separately. I've got over 100K lines of data so a shortcut would
really help
|