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

%3CLINGO-SUB%20id%3D%22lingo-sub-2929572%22%20slang%3D%22en-US%22%3ECreating%20a%20new%20column%20with%20both%20the%20date%20and%20time%20in%20same%20place%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2929572%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20function%20can%20I%20use%20to%20combine%20the%20date%20and%20time%20(which%20are%20currently%20in%202%20separate%20columns)%20into%201%20column%3F%20I%20have%20tried%20using%20%3Dconcat%20but%20this%20takes%20my%20values%20and%20divides%20them%20because%20it%20is%20a%20date%20in%20format%20dd%2Fmm%2Fyy%20and%20hh%3Amm%20PM%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2929572%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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.