Concatenate Date and Time.

Concatenate Date and Time together in a Cell.

Using CONCATENATE and TEXT functions together to change Format of Date and Time.

Note that "&" is used as separator and a "space" is also added between Date and Time.

The Columns will display Date and Time in only that Format which will be mentioned in the TEXT Function....