Forum Discussion
katherinebee13
Nov 05, 2021Copper Contributor
Creating a new column with both the date and time in same place
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
- Detlef_LewinSilver ContributorCONCAT() does not divide - it appends.
You are looking for A1+B1.