Forum Discussion
combining date time columns
I have a number of worksheets with separate date and time columns. I need to combine them into a single column with a space between the date and time, 12-22-2017 12:30, for example. I realize I can...
You can just autofill the column. You may need to use the TEXT() function to combine the two values. Typically concatenate is for string values. You may run into formatting issues. Try these two:
=TEXT(A2, "m/d/yyyy")&" "&TEXT(B2, "h:mm")
or
=A2+B2 (this adds the values together.....)
Autofill Link: http://www.excelfunctions.net/Excel-Autofill.html
