How Do I Concatenate TEXT And Dates In Excel?
2022-05-29
Enter this formula =Concatenate(A3,” “,TEXT(B3,”mm/dd/yyyy”) into a blank cell besides your data. Or alternatively can use the second formula as =A4&” “&TEXT(B4,”dd/mm/yyyy”) into a black cell besides your data. How do I concatenate date month and day in Excel? Concatenate year, month and day to date with formula 1. SelectRead More →