How to combine date and time columns in Excel

If you have separate columns formatted as date and time in Excel and you'd like them combined, use a formula that converts each cell's value to a text format BEFORE combining them to make sure they keep their date/time format in the new column. You can also copy the new column and paste the values only to remove the formula dependency in additional sheets or columns. This video demonstrates this method of converting values to text before concatenating.

Subscribe to this channel: https://bit.ly/3fWYhZQ
Donate to help support: https://bit.ly/3AE3M99
LinkedIn: LinkedIn: nchambe
Website: https://NateChamberlain.com