• Home  / 
  • Excel
  •  /  Combine Text with Date or Time in Excel – Reporting Tips

Combine Text with Date or Time in Excel – Reporting Tips

Meme Concatenate with text

Many time you prepare financial reports in multiple sheets where you have to mention the date of signing report along with the certain text. Combine text with date by following these simple steps.

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

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 date is as follows:

combine text with data

Join two data

(Image 1)

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.
combine text with date

Merger cell having text and date

(Image 2)

Hey I #justgotthis good read on

Tweet this blog with your friends!

Detail discussion of the Text formula in context of date formatting

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 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 on Tricks of Text to Columns in MS Excel

Comment below regarding Userform

About the author

Sagar Doshi

  • Yes, Excel’s TEXT function is great for formatting in the desired manner.