Excel Column Merge: Combine Cells or Join Text in Excel?

How-to basics · Updated November 18, 2026

In Excel, “merge columns” can mean either joining cells visually or combining the text they contain. To make one larger cell, select the cells and choose Home > Merge & Center; to combine their contents without discarding data, use a formula such as =A2&" "&B2.

What “merge columns” means in Excel

Excel has two different operations that people commonly describe as merging columns. The first is merging cells: several adjacent cells become one larger cell on the worksheet. This changes the layout, but it does not combine the values from all those cells. When you merge a range, Excel keeps the content in its upper-left cell and removes the other contents in the selected range.

The second operation is combining text, also called concatenating. It takes values from separate cells and produces a combined result in another cell. For instance, joining a first name in column A and a last name in column B can create a full name in column C. The original cells can stay intact, which is usually preferable for lists and datasets.

It helps to decide which meaning you intend before changing a worksheet. A merged heading may make a report easier to read, while combined text may be needed for a mailing list or an export. Using the visual merge command when you meant to join data can cause information loss.

How to merge cells across columns

In Excel for Microsoft 365 on Windows, select the adjacent cells you want to turn into one cell. Then go to Home > Merge & Center. The main button merges the selection and centers the content. To choose another behavior, open the button’s drop-down menu.

  • Merge & Center combines the selected cells into one and centers the remaining content.
  • Merge Across merges cells separately across each selected row. For example, selecting A1:C3 creates one merged cell in each of rows 1, 2, and 3.
  • Merge Cells merges the selection without centering its content.
  • Unmerge Cells separates a previously merged range back into individual cells.

Only the upper-left cell’s value is retained when a selected range contains multiple populated cells. Excel displays a warning before removing the other values. Read it carefully: choose the option to continue only if losing those other cell contents is acceptable. You can use Undo immediately afterward if you made a mistake, but it is safer to copy the range first.

Excel for Mac has a similar merge control on the Home tab, though the ribbon’s appearance can vary with the version and window size. Excel for the web also offers cell merging from its Home ribbon. If a command is not visible, look for the Merge & Center drop-down or expand the ribbon. The meaning of the merge options is the same: they change the cell layout, not the underlying values into a combined string.

How to combine the contents of columns

For data that should become one text value, put a formula in an empty destination cell. With a first name in A2 and a last name in B2, enter this formula in C2:

=A2&" "&B2

The formula assumes A2 contains “Maya” and B2 contains “Chen”; the result in C2 is “Maya Chen.” The ampersand joins pieces together, and the quoted space inserts a separator. If you omit the separator, the result would be “MayaChen.” You can use a comma and space, a hyphen, or another text separator instead.

To apply the formula to more rows, select C2 and drag the small fill handle at the lower-right corner of the cell down the column. Excel adjusts the references for each row, so the next row refers to A3 and B3. For a large continuous data range, double-clicking the fill handle can fill down alongside neighboring data. Check the first and last results, especially if there are blank rows.

If you need to combine several cells and skip blanks, TEXTJOIN is useful. With values to combine in A2:C2 and a space between words, use:

=TEXTJOIN(" ",TRUE,A2:C2)

If A2 contains “Maya,” B2 is empty, and C2 contains “Chen,” the result is “Maya Chen”; the TRUE argument tells Excel to ignore empty cells. TEXTJOIN is available in Microsoft 365 and Excel 2019 or later. For a simple two-cell combination, the ampersand formula is broadly compatible and often easier to understand.

Choose the right method for the job

Use merged cells mainly for presentation: a report title spanning several columns is a typical example. Use a formula when you need a new combined value, and keep the source columns if you may need to edit, sort, filter, or reuse the original parts later. These two techniques solve different problems; one is a layout change and the other is a data transformation.

  • Make a heading span columns: merge the cells, after confirming that only the upper-left cell needs to contain content.
  • Combine names, codes, or address parts: use a formula in a separate column.
  • Join values for a one-time handoff: create a formula result, then copy it and use Paste Special > Values if you need fixed text rather than a live formula.
  • Keep a clean data table: avoid merged cells in the rows that hold records; put headings above the table instead.

There is no general “merge columns” command that safely combines every value in the selected columns into one cell. If you have a long range, decide how the results should be separated and whether blank cells should be skipped before choosing a formula or a data-cleaning workflow.

What happens to the original data

Merging is potentially destructive because a merged cell can hold only one value. If the range contains, for example, a title in A1 and a date in B1, merging A1:B1 keeps the value in A1 and discards the value in B1 after you confirm the warning. The cells do not become a combined string, and Excel does not preserve the removed value in a hidden part of the merged cell.

Unmerging does not restore discarded content. It restores the cell grid, but the original value remains only in the cell that was at the upper-left of the merged range; the other cells are blank. If you need both values, cancel the merge warning and combine them with a formula, or copy the data elsewhere before merging.

Formula-based combining is less risky because it leaves the source cells alone. However, the result is linked to those cells: if a source value changes, the formula result updates. If you want to freeze the result, copy the formula cells and use Home > Paste > Paste Special > Values. This replaces the formulas with their current displayed results, so keep a copy of the original data if you may need to revise the combination later.

Common problems and limitations

A frequent surprise is that Merge & Center does not combine multiple values. Excel’s warning is important, not a routine confirmation. Another common issue is a formula that runs words together because no separator was included. Add a space or punctuation inside quotation marks, as in the name example above, and confirm the displayed result looks right.

Merged cells can also make ordinary worksheet tasks awkward. Sorting a range with merged cells of different sizes can produce an error or an unexpected layout, and filtering or selecting ranges can be less straightforward. Many Excel table features require a regular grid, so merged cells are not suitable inside an Excel table. If the Merge command is unavailable, check whether the selected cells are part of a table or whether the worksheet is protected.

When the merge options are disabled, consider whether multiple worksheets are grouped, whether the selection includes an Excel table, or whether editing restrictions apply. You can click a worksheet tab to check for grouped sheets; if several tabs are selected, right-click a selected tab and choose Ungroup Sheets before editing. If protection is enabled, you may need permission to unprotect the sheet. Avoid removing protection unless you are authorized to do so.

For a formula, check that the destination cell is not inside the source range and that the references point to the intended row. If a result looks wrong, inspect for leading or trailing spaces in the source cells. A formula can join text faithfully while carrying those extra spaces along. Cleaning source data may be necessary when values come from imports or inconsistent manual entry.

Better layouts than merged cells

If the goal is simply to center a heading across several columns, Excel provides a layout alternative: select the heading cell and the adjacent cells across which it should appear, then open the Format Cells dialog with Home > Alignment dialog launcher. On the Alignment tab, set Horizontal to Center Across Selection. This centers the text across the selected cells without merging them. It can preserve a more regular cell grid, which is helpful for sorting and editing.

Another option is to put the heading in one cell and adjust column widths, wrapping, or alignment so it fits. For a data table, use one descriptive heading per column rather than merging a heading across the data columns. This keeps each column independently addressable and makes the range easier to filter, sort, and use in formulas. The best choice depends on whether the worksheet is a report for people to read or a structured dataset for Excel to process.

Frequently Asked Questions

Can I merge two Excel columns without losing data?

Not with the Merge Cells command: it retains the upper-left value and discards other selected values after confirmation. To preserve both, combine them in a separate cell with a formula, such as =A2&" "&B2, and keep the original columns.

How do I merge cells without centering the text?

Select the cells, then choose Home > Merge & Center drop-down > Merge Cells. This merges the range without applying the centering behavior of the main Merge & Center button.

How do I undo or reverse a merge?

Use Undo immediately after merging if the change was just made. Otherwise select the merged cell and choose Home > Merge & Center drop-down > Unmerge Cells. Unmerging does not recover any values that were discarded during the original merge.

Can I merge cells in an Excel table?

Merged cells are not supported as part of a normal Excel table’s structured grid. If the command is unavailable, convert the table to a regular range only if losing table features is acceptable, or place the heading outside the table and leave its data cells unmerged.

How can I join a whole column of names?

Enter a joining formula in the first destination row, then fill it down for the matching records. For example, with first names in A2:A100 and last names in B2:B100, put =A2&" "&B2 in C2 and fill down. The result is one full name per row while the original columns remain available.

Related

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.