Combine Text with Date or Time in Excel – Reporting Tips

Yodalearning>Tutorials>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 a 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 the date is as follows:

Imgae-1-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.

Image-2-Merger-cell-having-text-and-date-1

(Image 2)

Tweet this blog with your friends!

Detail discussion of the Text formula in the 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 a date with ease, thereby increasing your productivity and efficiency.

Format codeOutput
d8
dd08
dddWed
ddddWednesday
m7
mm07
mmmJul
mmmmJuly
mmmmmJ
yy15
yyyy2015
mm/dd/yyyy07/08/2015
m/d/y7/8/15
ddd, mmm dWed,Jul 8
mm/dd/yyyy h:mm AM/PM07/08/2015 3:21 PM
dd/mm/yyyy hh:mm:ss07/08/2015 15:21:00

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

comment-below

Advanced Excel Course

Your courses were useful for me. Thank you again for your quick support and also for your availability.

- Madalina Elena Gheorghe

Free Excel Course
with 210+ Tricks
(UPDATED 2017)