Creating a new column with both the date and time in same place

Copper Contributor

Hello 

What function can I use to combine the date and time (which are currently in 2 separate columns) into 1 column? I have tried using =concat but this takes my values and divides them because it is a date in format dd/mm/yy and hh:mm PM

 

 

1 Reply
CONCAT() does not divide - it appends.
You are looking for A1+B1.