Quick, clean, and to the point

Join date and text

Excel formula: Join date and text
Generic formula 

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")

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.

Dave Bruns

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.

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.