How to Combine Cells in Excel and Keep Text

To combine the text from cells without losing anything, enter a formula such as =A2&" "&B2 in an empty cell; it joins the contents of A2 and B2 with a space. Do not use Merge Cells to combine text: merging keeps only the upper-left cell’s contents and can discard the rest. If you want one larger cell for a heading, merge cells only after checking that the other selected cells are empty.

In Excel for Microsoft 365 on Windows, combining cell contents and merging cells are two different jobs. This guide shows how to join text while preserving every value, how to make the result permanent, and when the visual Merge Cells command is appropriate. The formulas also work in Excel for Mac and Excel for the web, though ribbon placement can differ slightly.

What You’ll Need

An Excel workbook with the cells you want to combine. Save a copy first if the data is important, especially before using a merge command.
An empty cell or column for the combined result. A formula cannot be entered into one of the source cells if you still need that source value.
A separator choice, if needed: a space, comma, hyphen, line break, or no separator. Decide whether blank cells should be ignored or represented in the result.

Step-by-Step

Check what you mean by combine. If you need all the words or values from multiple cells in one text result, use a formula. If you only want a larger-looking cell for a title and do not need to retain separate cell contents, use Merge Cells. For example, joining a first name and surname is a text-combining task; centering a heading over several columns is usually a layout task. This distinction matters because merging does not concatenate the selected cells.
Keep your source data intact. Before changing the layout, confirm where the original values are and leave them in place while you build the result. If your names are in A2 and B2, put the joining formula in C2 or another blank cell. This makes it easy to check the output and correct the separator without retyping either name.
Join two cells with a space. With Grace in A2 and Hopper in B2, enter this formula in C2: =A2&" "&B2. The result is Grace Hopper. The ampersand joins text, and the quoted space inserts a visible gap between the two cell values. Without that separator, the result would be GraceHopper. Replace the space between the quotation marks with a comma, hyphen, or other text if that suits your data.
Use CONCAT when you prefer a function. With Grace in A2 and Hopper in B2, enter this formula in C2: =CONCAT(A2," ",B2). It returns Grace Hopper, just like the ampersand version. CONCAT can join cell references and typed text in the same formula. For two cells, the ampersand is often quicker; CONCAT can feel clearer when a formula has several pieces. Both methods leave the original cells unchanged.
Join several cells and handle blanks. With Blue, Green, and Gold in A2:C2, enter this formula in D2: =TEXTJOIN(", ",TRUE,A2:C2). The result is Blue, Green, Gold. The first argument supplies the comma-and-space separator, and TRUE tells Excel to ignore empty cells. This is useful when some rows have missing middle names or optional details. To keep a place for every blank cell instead, change TRUE to FALSE; consecutive empty cells may then produce repeated separators.
Choose a line break when the result should stack. With North, Central, and South in A2:A4, enter this formula in B2: =TEXTJOIN(CHAR(10),TRUE,A2:A4). It joins the entries with a line break and ignores empty cells. Select B2, then choose Home > Wrap Text so the lines display inside the cell. Increase the row height if necessary. The line break is part of the cell’s text, so copying the result into another application may preserve the line breaks depending on the destination.
Copy the formula down for more rows. If each row has a first name in column A and surname in column B, use the formula in C2 and fill it down: select C2 and drag the small square at its lower-right corner down through the rows. Excel adjusts the references for each row, so C3 joins A3 and B3. Double-clicking the fill handle can fill down alongside a neighboring column of continuous data. Check the last few rows to make sure the fill reached the intended range.
Make the combined text permanent if required. A formula result updates when its source cells change. To keep the current text but remove the formulas, select the result cells, copy them, then choose Home > Paste > Values. In Windows, the Paste Values option is also available from the right-click menu and is usually marked with a 123 icon. Check the pasted results before deleting or editing the original columns. Once values are pasted, they no longer update when the source changes.
Merge cells only for a visual layout. Select the adjacent cells you want to turn into one larger area, then choose Home > Merge & Center ▼ > Merge Cells. The drop-down may show Merge & Center as the main button; use its arrow to select the specific merge option. If more than the upper-left cell contains data, Excel warns that merging keeps only the upper-left value and discards the other selected values. Cancel, combine the text with a formula first, and verify the result before merging. If the selection is just a heading across empty cells, merging may be suitable.

For a heading that only needs to look centered across columns, consider avoiding a merge altogether. Select the cells, open Format Cells, choose the Alignment tab, and set Horizontal to Center Across Selection. This keeps the cells separate, which can make sorting and filtering a table easier. Excel for Mac and Excel for the web use the same joining formulas; their ribbon layouts and dialog access may differ, so use the equivalent Merge or Format Cells controls available in that version.

Common Mistakes

Using Merge & Center to join words. Merge changes the cell layout; it does not combine all selected text. In a selection with several populated cells, the upper-left value is retained and the others can be discarded. Use a formula first when every entry matters.
Forgetting to include a separator. A formula such as =A2&B2 joins text directly. If the values are Alex and Lee, the result is AlexLee. Add a quoted space or punctuation between the references when you want separation.
Expecting a formula result to be fixed text. A formula remains linked to its source cells. That is helpful if the source can change, but it may not suit an export or final report. Use Paste Values when you intentionally need a static copy.
Deleting source columns too soon. If you delete cells that a formula uses, Excel may show a reference error or change the formula. Confirm the result, paste values if appropriate, and only then remove source data you no longer need.
Confusing a displayed number with its underlying value. When joining a number with text, Excel may show the raw number rather than its currency, date, or percentage formatting. Use TEXT to specify the format you want in the combined result.

Tips

Use TEXTJOIN for a range with a consistent separator and possible blanks. Its ignore-empty setting avoids extra commas or spaces when a cell is blank.
Use the ampersand for a short, readable formula and CONCAT when you want a function-based expression. For many cells with a delimiter, TEXTJOIN is usually the more convenient choice.
With a label in A2 and an amount of 1250 in B2, enter this formula in C2 to show a currency value: =A2&" - "&TEXT(B2,"$#,##0.00"). If A2 contains Invoice, the result is Invoice – $1,250.00. TEXT applies the chosen display format as part of the joined text.
Use Find and Replace or a formula adjustment only after checking whether spaces are meaningful. Extra spaces can be trimmed later, but removing all spaces indiscriminately can change names, addresses, or product descriptions.
Keep combined text in a new column until you have checked several representative rows, including rows with blank cells, long entries, and punctuation. A quick spot check can catch missing separators or unexpected formatting before the results are shared.

Troubleshooting

The merge warning says some data will be discarded. Choose Cancel if you need the values in every selected cell. Put a joining formula in a separate empty cell, confirm that the result contains all the desired text, and then decide whether the original range still needs to be merged. Do not confirm the warning just to see what happens; the discarded values may not be recoverable after other edits.

The formula displays as text instead of calculating. Check that the entry begins with an equals sign and that the cell is not formatted as Text. Change the cell format to General, then re-enter the formula or press F2 and Enter. Also check for an apostrophe or leading space before the equals sign, which makes Excel treat the entry as text.

The result has missing spaces or unwanted punctuation. Edit the separator inside the formula. In TEXTJOIN, the first argument is the delimiter, so a comma followed by a space is different from a comma alone. If you used ampersands, place the exact separator inside straight double quotation marks between the cell references.

Numbers or dates look different after joining. Excel stores dates and numbers as underlying numeric values, and concatenation may expose that value instead of the display format you see in the source cell. Wrap the numeric reference in TEXT and specify a suitable format code. For example, use a date format such as TEXT(B2,"mmm d, yyyy") inside the larger formula if B2 contains a date. Check the output for your required date style.

TEXTJOIN or CONCAT is not recognized. Confirm that the formula name is spelled correctly and that the installed Excel version supports the function. These functions are available in current Excel versions, including Microsoft 365. If an older edition does not recognize a function, use the ampersand method for a small number of cells. Some regional settings also use semicolons instead of commas between formula arguments; use the separator Excel expects in your installation.

Frequently Asked Questions

Can I combine cells and keep the original cells too?
Yes. Enter the formula in a separate empty cell or column. It creates a combined result while leaving the source cells unchanged. Keep the formula if you want the result to update when the sources change, or paste values if you want a static copy.

Does Merge Cells keep all the text?
No. When multiple selected cells contain data, Excel keeps the upper-left cell’s value and discards the other cell contents. Combine the contents with a formula before merging if you need to preserve every value in one text string.

How do I combine cells without a space?
Join the references directly, for example =A2&B2, or use CONCAT without a separator argument between them. This is useful for IDs or codes that should have no gap. For ordinary names or phrases, add a space to avoid words running together.

Can I combine cells with a comma and skip blanks?
Yes. Use TEXTJOIN with a comma-and-space delimiter and TRUE for the ignore-empty argument. For instance, with entries in A2:C2, =TEXTJOIN(", ",TRUE,A2:C2) returns the nonblank entries separated by commas and spaces.

Can I undo a merge or a text-combining formula?
Press Ctrl+Z on Windows immediately after an unwanted action. On Mac, use Command+Z. Undo works for recent worksheet edits, but it is not a safe substitute for a backup if you have continued working or closed the workbook. A formula is easy to edit or delete; lost values from a merge may require undoing the merge or restoring an earlier copy.

Will these steps work on Excel for Mac or the web?
The ampersand, CONCAT, and TEXTJOIN formulas work in current Excel for Mac and Excel for the web. The exact ribbon arrangement and some dialog options can vary. Use the version’s Home tab for merge controls, and turn on Wrap Text to display formula-generated line breaks.

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.