Forum Discussion

jim borchers's avatar
jim borchers
Copper Contributor
May 11, 2018

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 use the concat command individually on each row. I have thousands of rows in each worksheet. Is there a global command that will speed this up?

 

excel
Formulas and Functions
  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    May 12, 2018

    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