Combine Cells in Excel With a Dash Between Text Values

To combine two cells in Excel with a dash between them, place the values in A2 and B2, then enter =A2&"-"&B2 in C2. If A2 contains North and B2 contains Zone, the result is North-Zone. This formula joins the cell contents without changing the original cells; you can fill it down to combine more rows.

What You’ll Need

An Excel workbook with the values you want to join, such as two columns of names, codes, or labels.
A blank column for the combined results. Using one helps keep the source values intact.
Microsoft Excel for Microsoft 365 on Windows, as this guide assumes. The basic ampersand formula also works in Excel for Mac and Excel for the web.

You do not need to enable a special setting or use a macro. Before starting, check that the cells you want to combine are in the same row and decide whether the dash should appear even when one of those cells is blank. That choice affects which formula is most suitable.

Step-by-Step

Identify the cells to join. For example, suppose A2 contains North and B2 contains Zone, and you want the combined text in C2. Keep the source values in their current cells. Combining their contents with a formula is different from merging cells: the formula creates a result in another cell while leaving both inputs available.
Select the result cell. Click C2, or choose the first empty cell beside your source data. If the source columns are different, adjust the references in the formula to match your layout. For instance, the formula must refer to the cells on the same row that contain the values you actually want to join.
Enter the formula with a quoted dash. With North in A2 and Zone in B2, enter =A2&"-"&B2 in C2. Press Enter. The displayed result is North-Zone. The ampersand joins the pieces together, and the quoted hyphen is inserted as literal text between the cell values. The quotation marks are part of the formula and should be straight double quotes.
Check the result before copying it. Confirm that the words are in the expected order and that the dash appears in the right place. If you meant to include spaces around it, use a different text separator in the formula, such as " - ". With A2 containing North and B2 containing Zone, that separator returns North – Zone. A plain "-" does not add spaces.
Fill the formula down for other rows. With the result in C2, click C2 and point to the small square at the bottom-right corner of its selection, called the fill handle. Drag it down alongside your data, then release. Excel adjusts the row references automatically: the next row uses A3 and B3, then A4 and B4, and so on. If you only need one result, you can skip this step.
Review the last copied row. Check a few results near the top and bottom of the filled range. Look for a missing value, an unexpected dash, or a row that joined the wrong columns. When your data has gaps, fill only as far as the rows you intend to process rather than dragging through unrelated information.
Keep formulas or make fixed text, as needed. The joined result is a formula, so it updates when A2 or B2 changes. If you want to preserve the current results without keeping formulas, select and copy the result cells, then use Home > Paste > Paste Values. In Excel for Mac, you can use the Paste Values option from the Paste menu; in Excel for the web, use Paste Values if it is offered in the paste options. Windows copy and paste shortcuts are Ctrl+C and Ctrl+V; on Mac, use Command+C and Command+V.

For a longer set of cells in a row, TEXTJOIN can place one dash between each nonblank value. With North in A2, a blank B2, and Zone in C2, enter =TEXTJOIN("-",TRUE,A2:C2) in D2. It returns North-Zone because TRUE tells TEXTJOIN to ignore empty cells. TEXTJOIN is available in Microsoft 365 and recent Excel versions, including Excel 2019. If you want a dash to remain for an empty position, the basic ampersand method gives you more direct control over each separator.

Dates and formatted numbers need a little more attention. When Excel joins a value into text, it may use the underlying value rather than the way the cell is displayed. With Project in A2 and a real Excel date of May 6, 2026 in B2, enter =A2&"-"&TEXT(B2,"mmm d, yyyy") in C2. The result is Project-May 6, 2026. The TEXT function specifies how the date should appear in the combined result; adjust its format pattern if you prefer a different display.

Common Mistakes

Using a minus sign instead of joining text. A formula such as =A2-B2 asks Excel to subtract numeric values. It does not insert a dash between text. Use ampersands and put the dash in quotation marks.
Leaving out the quotation marks. In =A2&-&B2, Excel does not recognize the hyphen as the text separator you intended. Write the dash as "-", including both straight quotation marks.
Expecting a blank cell to remove its neighboring dash. The formula =A2&"-"&B2 always inserts the dash. If A2 is North and B2 is blank, it returns North-. If you do not want separators next to empty cells, use TEXTJOIN with its ignore-empty argument set to TRUE, as shown above.
Merging cells instead of joining their contents. Home > Merge & Center changes the cell layout; it is not the way to combine the values from separate cells into one text result. Use a formula when you need both source values represented in the output.
Overwriting source data too soon. Typing the formula into a cell that contains one of the original values replaces that value. Put the result in an empty column, and check that it is correct before removing or replacing any source data.
Assuming a formula result is permanent text. A formula recalculates when its referenced cells change. If the result must stay fixed, copy it and paste values into the destination cells.

Tips

Choose the dash style deliberately. A hyphen (-), en dash (–), and em dash (—) are different characters. For a common code or label, the hyphen is usually appropriate. If a longer dash is needed, copy that character between the formula’s quotation marks.
Preserve leading zeros in codes. If a source value is stored as a number, Excel may not retain zeros that are only part of its display format when it joins the value into text. Store identifiers as text when possible, or use TEXT with a suitable format for the number. Avoid changing an identifier to a number if its leading zeros matter.
Use a dedicated output column. Keeping original values beside the result makes it easier to verify a batch, correct an input, or change the separator later. Add a clear heading, such as Combined, above the output column.
Test on one row first. Confirm the spelling, punctuation, and blank-cell behavior on a small sample before filling hundreds of rows. This is especially helpful when combining imported lists, product codes, or names with inconsistent spacing.
Remember that the formula follows cell references. If you sort only the result column, its rows can become separated from the source data. Sort the full table or range so each row’s inputs stay together.

Troubleshooting

The formula appears in the cell instead of its result. Check whether the cell is formatted as Text, or whether the formula begins with an apostrophe. Change the cell format to General, remove any leading apostrophe, and enter the formula again. Changing the format alone may not make an already-entered formula calculate; re-enter it by selecting the cell, pressing F2, and then pressing Enter.

The result shows a number where you expected a date. Excel may be displaying the date’s underlying serial number after joining it with text. Use the TEXT approach in the Step-by-Step section to specify a date format. The output of a join is text, so formatting the result cell as a date will not format only the date portion inside that text.

There is a dash at the beginning or end. One of the referenced cells may be blank. The basic formula inserts a dash whether or not both inputs have content. If empty cells should be skipped, use TEXTJOIN with TRUE as the second argument. If the cells contain spaces rather than being genuinely empty, remove those extra spaces from the source values or clean them before joining; a space can make a cell look blank while still containing a character.

The formula returns an error or an unexpected result. Check that the cell references point to the intended row, that each text separator is enclosed in straight double quotes, and that the formula starts with an equals sign. If you copied the formula from formatted text, replace curly quotation marks with straight ones. Also check that the result cell is not part of a merged area that prevents normal entry or filling.

The copied results repeat the same row. Click a result lower in the filled range and inspect the formula in the formula bar. Relative references should change by row, such as A2 and B2 becoming A3 and B3. If a reference has dollar signs, such as $A$2, it is fixed; remove the dollar signs if you want that reference to move as you fill down.

Frequently Asked Questions

Can I combine three or more cells with a dash?
Yes. For a short, fixed set of cells, join each reference with a quoted dash between it. For a range that may include blank cells, TEXTJOIN is often clearer because it can skip empty cells and place the separator between the remaining values.

Will combining cells delete or change the original values?
No. A formula in a separate cell leaves the original cells unchanged. The result updates if an input changes. To keep only a fixed copy of the displayed result, copy it and use Paste Values.

How do I avoid a dash when one cell is blank?
Use TEXTJOIN and set its second argument to TRUE so empty cells are ignored. This is usually the simplest option when joining a row or range and you do not want a separator where a blank value occurs.

Can I add spaces around the dash?
Yes. Put a space on each side of the hyphen inside the quoted separator, so the finished text reads like North – Zone rather than North-Zone. Be consistent if the result is a code or value that another system must match exactly.

Does this work in Excel for Mac or Excel for the web?
Yes. The ampersand formula and TEXTJOIN are available in current Excel for Mac and Excel for the web. The formula syntax is the same; some paste menus and shortcut keys differ. On Mac, use Command with C or V for copy and paste rather than Ctrl.

Can I put the dash between parts of a date or number?
Yes, but first decide how each value should display. For dates or numbers with leading zeros, use TEXT to specify the display format inside the combined result. Otherwise Excel may use the underlying value, which can look different from the format shown in the source 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.