How to Combine Date and Text in Excel (5 Methods)

Method 1 – Using CONCATENATE or CONCAT Function to Combine Date and Text in Excel

To maintain the proper format of a date or a time in a cell that include text, we have to use the TEXT function while concatenating the information. The TEXT function converts a value into a specific number format.

Use of CONCATENATE or CONCAT Function to Combine Date and Text in Excel

In Cell B8, enter the below formula and press enter.

=CONCATENATE(B5," ",TEXT(C5,"DD-MM-YYYY"))

Or,

=CONCAT(B5," ",TEXT(C5,"DD-MM-YYYY"))

Use of CONCATENATE or CONCAT Function to Combine Date and Text in Excel

The complete statement including the date is returned in a customized format.

Use of CONCATENATE or CONCAT Function to Combine Date and Text in Excel


Method 2 – Using Ampersand (&) Operator to Join Date and Text in Excel

We can also use the Ampersand (&) to combine a text and a date.

Enter the following formula.

=B5&" "&TEXT(C5,"DD-MM-YYYY")

Use of Ampersand (&) to Join Date and Text in Excel

 

Use of Ampersand (&) to Join Date and Text in Excel


Method 3 – Using TODAY Function to Combine Text with Current Date

The TODAY function shows the current date. Maintain the format of the date by using the TEXT function before the TODAY function.

Enter the following formula in cell C8 and press enter.

=B5&" "&TEXT(TODAY(),"DD-MM-YYYY")

Use of TODAY Function to Combine Text with Current Date

The following combined statement is returned.

Use of TODAY Function to Combine Text with Current Date


Method 4 – Using the TEXTJOIN Function to Combine Date and Text in Excel

If you’re using Excel 2019 or Excel 365 you can utilize the TEXTJOIN function to combine dates and text.

In Cell B8, enter the following formula.

=TEXTJOIN(" ",TRUE,B5,TEXT(C5,"DD-MM-YYYY"))

Use of TEXTJOIN Function to Connect Date and Text in Excel

Press Enter.

Use of TEXTJOIN Function to Connect Date and Text in Excel


Method 5 – Combine Text with Both Date and Time in Excel Using TEXT Function

In this example we need to return a statement that includes both a time and a date, as well as text, eg, “The item was delivered at HH:MM:SS AM/PM on DD-MM-YYYY”

Enter the following formula in cell C8.

=B5&" at "&TEXT(D5,"HH:MM:SS AM/PM")&" on "&TEXT(C5,"DD-MM-YYYY")

Combine Text with Both Date and Time in Excel

 

Combine Text with Both Date and Time in Excel


Download Practice Workbook

 

 


Further Readings


<< Go Back to Concatenate Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Nehad Ulfat
Nehad Ulfat

NEHAD ULFAT is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including ABACUS, AutoCAD, Rhinoceros, Maxsurf, and Hydromax. He got his B.Sc in Naval Architecture & Marine Engineering from BUET but switched gears, working as a content developer.  In this role, he creates techy content all about Excel... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo