Exceljet

Quick, clean, and to the point

Join date and text

Excel formula: Join date and text
Generic formula 
="text"&TEXT(date,format)
Summary 

To join a date with text, you can use concatenation with the TEXT function to control the date format. In the example shown, the formula in E4 is:

="The date is "&TEXT(B4,"dddd, mmmm yyyy")
Explanation 

The core of this formula is concatenation using the ampersand (&) operator:

="The date is"&date

However, if you simply join a date with text and don't control the date format, the date will revert to it's raw serial number format, and the result will look like this:

"The date is 42887".

To control the date format, use the TEXT function, which is designed to convert a number into text using a specified number format. This article shows a list of codes you can can use for date formats.

Author 
Dave Bruns
Related formulas 
Excel formula: Get day name from date
Get day name from date
If you need to get the day name (i.e. Monday, Tuesday, etc.) from a date, there are several options depending on your needs. Do you want to convert the date into a day name? If you want to convert the date value to a text value, you can use the TEXT...
Excel formula: Get month name from date
Get month name from date
Do you want to convert the date into a month name? If you want to convert the date value to a text value, you can use the TEXT function with a custom number format like "mmmm", or "mmm". In the example shown, the formula in cell C4 is: = TEXT ( B4...
Excel formula: Convert date to text
Convert date to text
Dates and times in Excel are stored as serial numbers and converted to human readable values on the fly using number formats. When you enter a date in Excel, you can apply a number format to display that date as you like. In a similar way, the TEXT...
Excel formula: Join cells with comma
Join cells with comma
Working from the inside out, the formula first joins the values the 5 cells to the left using the concatenation operator (&) and a single space between each value: B5 & " " & C5 & " " & D5 & " "...
Related functions 
Excel TEXT function
Excel TEXT Function

The Excel TEXT function returns a number in a given number format, as text. You can use the TEXT function to embed formatted numbers inside text.

Related courses 
Core Formula

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

500 Formulas | 101 Functions

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.