Combine Cells in Excel With Dates Without Losing Format

To combine a date with text without displaying its underlying serial number, use a formula that applies TEXT to the date first. With a real Excel date in A2 and related text in B2, enter =TEXT(A2,"mmm d, yyyy")&" - "&B2 in another cell. If A2 is March 8, 2026, and B2 is Planning, the result is Mar 8, 2026 – Planning. This joins the values in a new cell; it does not merge the original cells.

What You’ll Need

A workbook in Excel for Microsoft 365 on Windows. The same formulas work in Excel for Mac and Excel for the web, though ribbon labels and shortcuts can differ slightly.
Dates stored as actual Excel date values, rather than text that only looks like a date. Select a date cell and check whether Excel recognizes it as a date by changing its number format or using it in a calculation.
A blank column or other empty cells for the combined results. Keeping the source data intact makes it easier to correct or change the output later.

Step-by-Step

Decide what “combine” means for your sheet. If you want a date and another value to appear together as one readable result, concatenate them with a formula. For example, you might join a delivery date with a status, or join a start date and end date into a date range. If you mean making several cells look like one larger cell, that is the separate Merge Cells feature; it does not join all the values inside them.
Check the source columns and choose a result column. Suppose dates are in A2:A20 and descriptions are in B2:B20. Put a heading such as Combined in C1, then use C2 for the first formula. Leave columns A and B unchanged. This layout gives you a result for each row and makes it possible to compare the output with its source values.
Format the date inside the formula. With the date in A2 and the description in B2, enter =TEXT(A2,"mmm d, yyyy")&" - "&B2 in C2. The TEXT function converts the date to the selected display format before the ampersands join it to the description. For A2 containing March 8, 2026, and B2 containing Planning, C2 displays Mar 8, 2026 – Planning. Change the quoted date pattern to suit your needs: "mmmm d, yyyy" displays March 8, 2026, while "yyyy-mm-dd" displays 2026-03-08.
Combine two dates as a range when needed. With a start date in A2 and an end date in B2, enter =TEXT(A2,"mmm d, yyyy")&" to "&TEXT(B2,"mmm d, yyyy") in C2. If A2 is March 8, 2026, and B2 is March 12, 2026, the result is Mar 8, 2026 to Mar 12, 2026. TEXT is applied to both dates because each one would otherwise be joined as its underlying number.
Use a different separator or include more information. The text between quotation marks is literal output. Replace " - " with ", ", " | ", or another separator. With a date in A2, a time in B2, and an event name in C2, enter =TEXT(A2,"mmm d, yyyy")&" at "&TEXT(B2,"h:mm AM/PM")&" - "&C2 in D2. For March 8, 2026, 9:30 AM, and Planning, the result is Mar 8, 2026 at 9:30 AM – Planning. The time also needs TEXT formatting to avoid a decimal or time serial display.
Fill the formula down the column. Select the cell containing the formula and drag its small fill handle at the lower-right corner down to the last data row. Alternatively, double-click the fill handle when the neighboring source column has continuous data. Excel adjusts relative references row by row, so the next formula refers to A3 and B3, then A4 and B4. Check a few rows to make sure each result matches the dates and descriptions beside it.
Choose the right method if you meant merge. Select the cells to join visually, then choose Home > Merge & Center and select the appropriate option from its dropdown. Merge & Center is for layout, not for preserving multiple cell values: Excel keeps the upper-left cell’s content and warns that other contents will be removed. Copy or combine any needed values elsewhere before merging. To avoid that data-loss issue, use a formula in a separate cell when the goal is to display both values.
Make the results permanent only if necessary. Formula results update when their source dates or descriptions change. If you need fixed text, copy the result cells, then use Home > Paste > Paste Values. This replaces the formulas with their current displayed results. Keep a copy of the original data first if you may need to revise the formatting or rebuild the output.

Common Mistakes

Joining a date without TEXT. Excel stores dates as numbers and applies a cell format to display them as dates. Joining a date cell directly with text can therefore produce a number such as 46089 instead of Mar 8, 2026. Wrap the date reference in TEXT and specify the display pattern. Formatting the result cell as a date afterward will not fix a string that already contains the serial number.

Confusing display formatting with the stored value. A cell may show 3/8/2026 while its stored value is a number. That is normal for a real Excel date. TEXT changes how the value appears in the combined result; it does not change the source date. If a source value is text rather than a recognized date, TEXT might not behave as expected, so convert or correct the source first.

Merging cells that contain separate data. Merge & Center does not concatenate values. When a selected range has content in more than one cell, Excel retains only the upper-left value and removes the others. Make a backup or use a formula to combine the information before merging. Merging can also interfere with sorting, filtering, and selecting ranges, so use it sparingly in data tables.

Forgetting spaces and punctuation. Excel does not automatically insert a space between joined values. Add the separator as quoted text in the formula, such as &" - "&. Without it, a date and a label can run together and become difficult to read.

Expecting the formula result to remain fixed. A formula changes when its referenced cells change. That is usually useful for a working sheet, but it can be unexpected when preparing a final report. Use Paste Values when you specifically need a fixed snapshot, and remember that the resulting text will no longer update with its source cells.

Tips

Pick a date style that suits the audience. "mmm d, yyyy" is compact and readable, while "yyyy-mm-dd" is unambiguous and sorts naturally when used consistently as text.
For a date that should display as March 8, 2026, use "mmmm d, yyyy". For a short weekday and date, use "ddd, mmm d", which displays Sun, Mar 8 for that date. The output depends on your regional settings for month and day names.
Keep a clear heading over the formula column and avoid overwriting the original date column. This makes later edits safer and helps another person understand which values are formulas and which are source data.
If you need to change the separator or date style for many rows, update the formula in the first result cell and fill it down again. This is usually faster and more consistent than editing each combined result by hand.
In Excel for Windows, Ctrl+1 opens Format Cells for changing the display format of source dates. On Mac, use Command+1. This changes how the source cell appears, but a concatenation formula still needs TEXT to control the date display within the combined text.

Troubleshooting

The result shows a number instead of a date: Edit the formula and wrap the date reference in TEXT with a format pattern, for example TEXT(A2,"mmm d, yyyy"). Applying a date format to the combined result cell is not a substitute, because the combined result is text.

The formula displays instead of calculating: Check whether the cell is formatted as Text. Change it to General, then select the formula cell, press F2, and press Enter to make Excel evaluate it again. Also check that the formula begins with an equals sign and that Show Formulas is not turned on. On Windows, Ctrl+` toggles Show Formulas; on Mac, the shortcut may vary by keyboard layout, so use Formulas > Show Formulas.

The date appears as a strange or incorrect value: Confirm that the source cell contains a real date and that the date order has not been misread when imported. If Excel has interpreted a text date using a different regional order, correct the source data before joining it. You can also adjust the TEXT pattern to make the intended month, day, and year clear.

The formula returns an error: Check that the referenced cells exist and that every opening parenthesis and quotation mark has a matching closing one. In Excel for Microsoft 365 on Windows, formulas normally use commas between function arguments, as shown in this guide. Some regional settings require semicolons instead; if Excel rejects a formula with commas, use the list separator configured for your installation.

Some rows are blank or include unwanted separators: Inspect the source cells for blanks, spaces, or values stored inconsistently. A formula that always adds a hyphen will still show the hyphen when the description is empty. Decide whether blank source rows should remain blank or display a partial result, then adjust the formula accordingly rather than manually editing individual outputs.

Frequently Asked Questions

Can I combine a date and text without losing the date format?
Yes. Apply TEXT to the date reference inside the formula, then join it to the text with ampersands. For example, TEXT(A2,"mmm d, yyyy") displays the date in a readable format within the result.

Does Merge & Center combine the contents of cells?
No. It joins the selected cells into a larger visual cell and retains only the upper-left cell’s content. Use a formula to combine values without discarding the other contents.

Can I combine two dates into one date range?
Yes. Format each date separately with TEXT and put a word or separator between them. For example, with the dates in A2 and B2, use =TEXT(A2,"mmm d, yyyy")&" to "&TEXT(B2,"mmm d, yyyy").

Will the combined result update when I change a date?
Yes, if the result is a formula. It recalculates when a referenced date or text value changes. Paste Values only when you want to replace the formula with a fixed result.

Can I use this method in Excel for Mac or the web?
Yes. The formulas and TEXT date patterns work in Excel for Mac and Excel for the web as well as Microsoft 365 for Windows. Some shortcuts and ribbon details differ, but you can enter the formula directly in a cell.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.