Date + Time

Copper Contributor

Hi,

I have date in one cell and time in another.  [13/02/2020], [22:02:53]

I need one cell with both.  [13/02/2020 22:02:53]

How do I do that automatically?

2 Replies

@AlonS67 Perhaps like this?

Screen Shot 2020-02-21 at 12.30.04.png

Format cell C1 as 

Screen Shot 2020-02-21 at 12.31.32.png

Tnx!!!