ExcelTutorials

Combine Text with Date or Time in Excel – Reporting Tips

1 Mins read

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.

Excel Vlookup formula – Guidebook

Excel Vlookup Formula

Bored of downloading text heavy / copy-pasted eBooks?

If Yes, you will enjoy this guidebook on ‘Excel Vlookup Formulas’ – VLOOKUP, HLOOKUP, MATCH & INDEX.

Combine text with a date by following these simple steps:

Hence it increases responsibility to update the date on 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

How 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-Merger-cell-having-text-and-date-1

How to Combine Date & Time in Excel

to merge/combine the date & time in excel cells, follow below steps,

Step 1: Here is the simple formula to combine Date & Time in Excel

Step 2: A2 indices the first date in Date Column & B2 is for Time Column

Step 3: Type this formula = TEXT(A2,”m/dd/yy “)&TEXT(B2,”hh:mm:ss”) into next column.

Step 4: Now you will get Combine Date & Time in Excel

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 a 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
y
15
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

Here are a few more examples of concatenating text, number, and date:

15 Pivot Tables Tricks for Pros

15 Pivot Table tricks to make your Excel data analysis smarter! 5,600+ downloads.

Most Popular Tricks are #3, #7 & #12

Related posts
AlteryxTutorials

Alteryx Hotkeys - Alteryx Keyboard Shortcuts

2 Mins read
Top 50+ Alteryx Shortcuts for Windows. Alteryx is popularly known as a Self-Service Analytics tool. Business users can build their data workflows…
AlteryxTutorials

Step By Step Guide to Learn Alteryx

6 Mins read
Alteryx Learning Path: The growth in technology has resulted in growth in understanding. In today’s world, humans – fellow businessmen know the…
Excel VBA CodeTutorials

VBA Code to Clean the Date Format

1 Mins read
When it is useful? Most of the time the most annoying problem is when the data is taken from ERP or other…