Combine Text with Date or Time in Excel – Reporting Tips

Many times you prepare financial reports in multiple sheets where you have to mention the date of signing report along with the certain text. There are multiple ways to combine text with a date or time in excel. If you want to learn more, please check our latest Excel Ninja Course for such type of Excel Tips & Tricks.   Meme-Concatenate-with-text

Combine text with a date by following these simple steps:

Hence it increases responsibility to update the date on each sheet.

Combine Text with Date or Time in Excel – Reporting Tips

Excel Power Users Ebook

Be Smart at Excel | New Skills for New JOB

This eBook will help you to get Excel Skills & Boost your career

• Course Certificate • Lifetime Access & Free Updates • Lifetime Support • Career Focused

What if you enter a proper date in one sheet and it automatically updates the date mentioned with combined text in other sheets of the workbook?

BUT…. Problem faced while combining the text with the date is as follows:

combine text with date and time in Excel

(Image 1)

To Combine text with Date & Time here is the 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.


(Image 2)

Tweet this blog with your friends!

Detail discussion of the Text formula in the context of date formatting:
• 200+ Video Tutorials • 90 Case Studies • 5 eBooks • 25 Presentation Decks • 4 Webinar • 24*7 Dedicated Support

Assuming a date of 08-07-2015 3:21:00 PM, here is a complete set of formatting codes for date, along with sample output. Combine text with a date with ease, thereby increasing your productivity and efficiency.

Format code Output
d 8
dd 08
ddd Wed
dddd Wednesday
m 7
mm 07
mmm Jul
mmmm July
mmmmm J
yy 15
yyyy 2015
mm/dd/yyyy 07/08/2015
m/d/y 7/8/15
ddd, mmm d Wed,Jul 8
mm/dd/yyyy h:mm AM/PM 07/08/2015 3:21 PM
dd/mm/yyyy hh:mm:ss 07/08/2015 15:21:00

Read related article:Tricks of Text to Columns in MS Excel