To combine a date in A2 with text in B2, use =TEXT(A2,"mmmm d, yyyy")&" "&B2. If A2 contains June 15, 2026 and B2 contains Appointment, the result is June 15, 2026 Appointment. The key is to wrap the date in Excel’s TEXT function so it displays as a readable date instead of its underlying number.
Why dates need special handling
Excel stores dates as serial numbers so it can sort them, calculate the number of days between them, and use them in other date calculations. A cell may show June 15, 2026 because it has a date format, even though the stored value is a number. When you join that value directly to text, Excel can show the serial number rather than the date format displayed in the original cell.
For example, joining a date with an event label using the ampersand operator may produce a result like 46188 Appointment instead of June 15, 2026 Appointment. That does not mean the date has been changed or lost; it means the combined result is text, and Excel is displaying the date’s underlying value in that text. The TEXT function converts the date value into the specific readable format you choose before joining it with the other content.
Once a date is part of a text string, the result is text rather than a date value. That is useful for a heading, message, or report label, but it means the combined result is not suitable for date arithmetic or date-based sorting as if it were a date cell.
Combine a date and text with the ampersand
The ampersand (&) joins text or values in a formula. It is a direct, flexible choice when you want to decide exactly where spaces, punctuation, and words appear. Use TEXT around each date that needs a particular display format.
With the date in A2 and the event name in B2, use =TEXT(A2,"mmm d, yyyy")&" — "&B2. For A2 equal to June 15, 2026 and B2 equal to Appointment, the result is Jun 15, 2026 — Appointment. The em dash and spaces are literal characters inside the quoted text.
To put the text first, change the order of the pieces. With the date in A2 and the status in B2, use =B2&" is scheduled for "&TEXT(A2,"dddd, mmmm d"). If B2 contains Inspection and A2 is June 15, 2026, the result is Inspection is scheduled for Monday, June 15. The weekday is calculated from the date value, so it updates if the date changes.
In formulas, text that you want to display literally must be enclosed in straight double quotation marks. A space is also text: include it inside a quoted section or Excel will run the joined pieces together. For instance, joining a first name in A2 and a last name in B2 requires a quoted space between them.
Choose a date format with TEXT
The second argument of TEXT is a number format written inside quotation marks. Common date patterns include:
"m/d/yyyy"for a numeric month, day, and four-digit year, such as 6/15/2026."dd-mmm-yyyy"for a two-digit day, abbreviated month, and year, such as 15-Jun-2026."mmmm d, yyyy"for a full month name and year, such as June 15, 2026."dddd, mmmm d"for a weekday and full month name, such as Monday, June 15.
With the date in A2 and an order number in B2, use ="Order "&B2&" is due "&TEXT(A2,"mmm d, yyyy"). If B2 is 1042 and A2 is June 15, 2026, the result is Order 1042 is due Jun 15, 2026. Pick a format that suits the reader and the purpose: a short numeric date is compact, while a month name can reduce ambiguity in text meant for an international audience.
Format codes also control details such as leading zeros. For example, d shows a day without a leading zero, while dd adds one; mmm gives an abbreviated month name, and mmmm gives the full name. Use yyyy for a four-digit year. If you need a time as well, include a time pattern such as h:mm AM/PM, taking care to separate the date and time with punctuation that makes the result easy to read.
Use CONCAT or TEXTJOIN for multiple pieces
For a small number of pieces, the ampersand is easy to scan. Excel also has CONCAT, which joins values or cell references, and TEXTJOIN, which can insert a chosen separator between multiple items. Neither function automatically preserves the visible date formatting of a date cell; convert dates with TEXT when you need a particular date display.
With a date in A2, a location in B2, and an event in C2, use =CONCAT(TEXT(A2,"mmm d, yyyy")," — ",B2," — ",C2). If the cells contain June 15, 2026, Room 4, and Training, the result is Jun 15, 2026 — Room 4 — Training. CONCAT is available in current Microsoft 365 Excel; older workbooks may use the compatible CONCATENATE function, although the ampersand is often the simplest option.
With the date in A2 and the three text labels in B2:D2, use =TEXTJOIN(" | ",TRUE,TEXT(A2,"yyyy-mm-dd"),B2:D2). If A2 is June 15, 2026 and B2:D2 contain North, Confirmed, and 1042, the result is 2026-06-15 | North | Confirmed | 1042. In this formula, the separator is a space, vertical bar, and space. TRUE tells TEXTJOIN to ignore empty cells in the listed references. TEXTJOIN is available in Microsoft 365 and newer Excel versions, including Excel 2019 and later.
TEXTJOIN is helpful for lists, but it is not a substitute for formatting each date. If a range contains several date cells and you pass the range directly to TEXTJOIN, Excel may use their underlying numeric values. For predictable output, format the date values with TEXT first, or build the result with individual references where you need different formats.
Build a reusable formula for rows of data
To combine values for many records, enter a formula in the first output row and fill it down. With dates in A2:A100 and descriptions in B2:B100, enter this in C2: =TEXT(A2,"mmmm d, yyyy")&" — "&B2. For the example row where A2 is June 15, 2026 and B2 is Appointment, C2 displays June 15, 2026 — Appointment. When the formula is filled down, Excel adjusts the references to A3 and B3, then A4 and B4, and so on.
On Windows, select the formula cell and drag its fill handle down, or copy it and paste into the target cells. Ctrl+D fills down when the cells above include the formula and the destination range is selected. On Mac, Command+D fills down; the fill handle also works. In Excel for the web, you can use the fill handle or copy and paste. If the source data is in an Excel table, entering a formula in a table column generally fills the formula through that column automatically.
Keep the combined output in a separate column if you still need the original date for calculations, sorting, or filtering. The formula result changes when its source cells change, which is usually preferable for a live report. If you need a fixed text snapshot, copy the results and use Paste Special to paste values; the exact menu wording may vary slightly by Excel platform.
Formula result versus changing the cell’s display
Combining a date and text is different from changing how a date cell looks. Number formatting changes the display of a date value while keeping it available for date calculations. Concatenation creates a text result. Use a formula when the output itself needs to contain both the date and other words, such as a printable label. Use cell formatting when you only need the date to look different in its own cell.
For example, selecting a date cell and choosing a display format will not add the words “Due:” or the contents of another cell to that value. Conversely, a formula such as TEXT(A2,…) joined to words produces text, so you should not expect to calculate a number of days from that combined result. Keep the original date in a separate cell and refer to it for any later date calculations.
To inspect or change a cell’s number format, select it and open Format Cells with Ctrl+1 on Windows or Command+1 on Mac. This changes the selected cell’s display, not the way a formula joins text. The TEXT function is the relevant tool when the date must be rendered in a specific style inside a formula-generated string.
Common problems and how to fix them
- A serial number appears: Put TEXT around the date reference and specify a format, for example
TEXT(A2,"mmm d, yyyy"). The date cell’s visible formatting does not automatically carry into a joined text string. - There is no space between words: Add a quoted space between the joined pieces, such as
&" "&. Spaces are not added automatically. - The formula displays as text: Check that the cell is not formatted as Text and that the formula begins with an equals sign. If the cell was already formatted as Text, change its format to General, then edit and re-enter the formula.
- The date looks wrong in another region: Numeric formats such as m/d/yyyy can be interpreted differently by readers. A month-name format such as mmmm d, yyyy makes the month explicit. Excel’s language and regional settings can also affect displayed names and separators.
- The formula returns an error: Confirm that the referenced cells contain the expected values and that quotation marks and parentheses are paired. Excel installations configured for a different list separator may require semicolons instead of commas; the examples here use the standard comma syntax.
Frequently Asked Questions
How do I combine a date and text without getting a number?
Use TEXT around the date before joining it. For a date in A2 and text in B2, =TEXT(A2,"mmm d, yyyy")&" "&B2 turns the date into readable text and adds a space before the other cell’s contents.
Can I combine a date and text with CONCATENATE?
Yes. With the date in A2 and a label in B2, use =CONCATENATE(TEXT(A2,"mmmm d, yyyy")," ",B2). CONCATENATE works in many older Excel versions, but the ampersand operator or CONCAT is usually more convenient in current Excel.
Can the combined result still be used as a date?
No. Once a date is joined with words, the result is text. Keep the original date in another cell if you need to sort by date, calculate an interval, or use date functions later.
How do I include the weekday in the combined text?
Use a weekday code in TEXT. With a date in A2 and a label in B2, =TEXT(A2,"dddd, mmmm d, yyyy")&" — "&B2 produces a result such as Monday, June 15, 2026 — Appointment.
Will the formula update if I change the date?
Yes. A formula that refers to the date cell recalculates when that cell changes, and the displayed text updates using the format code in TEXT. If you paste the formula’s result as a value, it becomes a fixed text snapshot instead.
Related
- Contact List Format in Excel: Columns, Setup, and Tips
- Contact List Excel Sheet: How to Build and Use One
- Contact List Excel Spreadsheet: Create and Manage It
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formula for Checkbook Ledger: Setup & ExamplesThe core Excel formula for a checkbook ledger is a running balance: =SUM($C$2:C2) entered in the balance column,…
- Excel COUNTIF Equal to a Number: Formula and ExamplesTo count cells equal to a number in Excel, use =COUNTIF(B2:B10,100), replacing the range and number with your…
- CAGR Calculation Formula in Excel: Examples and TipsIn Excel, calculate CAGR by dividing the ending value by the beginning value, raising that ratio to the…
- Excel FILTER Function: Multiple Criteria and ExamplesYes. In Microsoft Excel for Microsoft 365, use the FILTER function with multiplication (*) to require multiple conditions…
- Excel Table Array Lookup: Using VLOOKUP in a TableAn Excel table array lookup usually means using the table_array argument in VLOOKUP: it tells Excel which range…
- Excel UNIQUE Function Not Showing? Causes and FixesIf Excel does not recognize or display UNIQUE, first check your version: the function is available in Microsoft…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.