Combine Text with Date in Excel

When trying to Concat Date and Text Field, the resultant is not in the expected date format. The problem faced while combining the text with the date is as follows:

Solution:

1. Enter this formula =Concatenate(A3,” “,TEXT(B3,”mm/dd/yyyy”) into a blank cell besides your data.
2. Or alternatively can use the second formula as =A4&” “&TEXT(B4,”dd/mm/yyyy”) into a black cell besides your data.

Combine Date & Time in Excel

To merge/combine the date & time in excel cells, follow the below steps,

Step 1: Here is the simple formula to combine Date & Time in Excel

Step 2: A2 indices the first date in Date Column & B2 is for Time Column

Step 3: Type this formula = TEXT(A2,”m/dd/yy “)&TEXT(B2,”hh:mm:ss”) into the next column.

Step 4: Now you will get Combine Date & Time in Excel