Google Sheets: How to Merge Cells With Text

In Google Sheets, select the cells and choose Format > Merge cells, then pick a merge option—but merging does not combine text from every selected cell. Sheets keeps the value in the upper-left cell and discards the other cell contents, so first join the text in a helper cell, put the result in the upper-left cell, clear the other cells, and then merge.

What Happens When You Merge Cells

A merge turns a selected rectangular range into one larger cell for display and editing. The top-left cell is the anchor: its value remains, while values in the other cells are removed. For example, merging A1:C1 when A1 contains “North,” B1 contains “Region,” and C1 contains “3” does not create “North Region 3.” The merged cell displays only “North.” Sheets may show a warning when the range contains more than one value; accepting the merge still means losing the non-anchor contents.

This distinction matters because “merge cells” can mean two different things. A spreadsheet merge changes the cell layout, while combining text means joining separate values into one text string. To keep all the words, combine them first; then merge only if the larger visual cell is useful. If the goal is just to make a heading look centered across columns, it may be better to leave the cells separate and use formatting or place the heading in one cell.

Combine Text Before Merging

Use a temporary cell outside the range you plan to merge. For example, suppose A2:C2 contain West, Wing, and 4. With those values in A2:C2, enter this in D2, or another empty helper cell:

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

The result is “West Wing 4.” TEXTJOIN joins the values with a space between them, and TRUE tells it to skip empty cells. If a source cell is blank, the formula avoids adding an extra separator for that blank. Review the result before proceeding, especially if the cells contain numbers, dates, or text that needs a particular separator or order.

Once the formula produces the wording you want, copy the helper cell. Select the top-left cell of the intended merge range and choose Edit > Paste special > Values only. This puts the result there as fixed text rather than leaving a formula that depends on the helper range. Clear the other cells in the range, then merge the range. Keep the helper until you have verified the merged result; delete it afterward if it is no longer needed.

Step-by-Step: Merge a Row of Text

Check the cells you intend to merge and note the text, order, and punctuation you want to preserve.
Choose an unused helper cell outside the selected range. For text in A2:C2, use the TEXTJOIN formula shown above in D2.
Confirm that the helper result reads correctly. If you want commas or another separator, use that separator in the formula instead of a space.
Copy the helper result, select A2, and use Edit > Paste special > Values only. The combined text is now stored in the upper-left cell.
Clear B2:C2 so those cells are empty. Select A2:C2 and choose Format > Merge cells > Merge horizontally.
Check the final cell and adjust alignment, wrapping, or column widths if needed.

For a rectangular range with more than one row and column, choose the merge option that matches the intended layout. Merge all combines the whole selection into one cell; it does not combine each row separately. If each row needs its own combined label, join each row’s contents and merge those rows one at a time, or avoid merging if the range is part of a data table.

Choose the Right Separator and Text Order

A space works for words that form a phrase, but it is not always the right choice. Use punctuation that makes the combined value readable and preserves meaning. Examples include a comma between city and state, a hyphen between a product code’s parts, or a line break when several entries should remain visually distinct. The order in the source range determines the order in the joined result, so arrange the cells correctly before relying on the formula.

For text in A2:A4 that should appear on separate lines inside one eventual merged cell, enter this formula in an empty helper cell:

=TEXTJOIN(CHAR(10),TRUE,A2:A4)

CHAR(10) supplies a line break. After moving the result into the top-left cell and merging, turn on text wrapping with Format > Wrapping > Wrap so the lines can display within the cell. The row may need more height to show every line. This approach preserves the distinction between entries without relying on commas or other punctuation.

Merge Options and When to Use Them

Google Sheets provides merge choices under Format > Merge cells. The available choices depend on the selection and include:

Merge all: Makes the entire selected block one cell. Use it for a single title spanning a rectangular area, not for a block of independent records.
Merge horizontally: Merges cells across each selected row. It is useful for a heading that spans columns within a row.
Merge vertically: Merges cells down each selected column. It can group a visual label across rows, but it can make sorting and editing tabular data harder.
Unmerge: Restores the original cell grid. It does not restore values that were discarded during the earlier merge.

You can also use the merge-cells button on the toolbar. If you do not see the relevant option, confirm that a range of at least two cells is selected. Merging is a layout operation, not a text-joining command, so choosing a different merge option will not concatenate the contents.

Formatting the Merged Text

After combining and merging, formatting determines whether the text is easy to read. For a heading, horizontal centering can make sense; for a long label, left alignment is often easier to scan. Use the alignment controls or the Format menu to adjust alignment. Use Format > Wrapping > Wrap when the content should continue on multiple lines instead of extending across empty cells or appearing clipped.

A merged cell occupies the visual width or height of the selected range, but the text still belongs to its top-left cell. If a long phrase remains difficult to read, consider widening the columns, increasing row height, or using a line break in the joined text. Merged cells can behave awkwardly when neighboring cells contain data or when the sheet is viewed at a different zoom level, so check the result at a practical screen size.

Common Problems and How to Avoid Them

Text disappeared: A merge retains only the top-left value. If you have not made further changes, Undo may reverse the merge, but do not assume it can recover data after later edits. Check version history or a backup if important contents were lost.
The formula shows an error: Check the range references and make sure the formula is in a cell outside the source range. In some spreadsheet locales, formula argument separators differ; if Sheets reports a formula parse error, check the locale’s expected separator.
The combined text is not in the right order: TEXTJOIN follows the order of the referenced cells. Change the range or rearrange the source values before creating the final merged cell.
There are unwanted spaces or punctuation: Choose a separator that suits the data. TEXTJOIN with TRUE skips blank cells, but it does not remove spaces already included at the start or end of a cell’s own text.
The text is hidden: Turn on wrapping, adjust row height or column width, and check alignment. A merge does not automatically make long content fully visible.
Sorting or filtering becomes difficult: Merged cells are a poor fit for ordinary tables where each row represents a record. Unmerge the range or use a separate heading row instead.

Before merging a large or important range, consider making a copy of the sheet or preserving the original values elsewhere. A merge can be undone immediately, but once other edits are made, recovering discarded cell contents may take more work. Also remember that only one cell in the merged area holds the value, which can affect formulas or scripts that expect data in every individual cell.

When Not to Merge Cells

Merging can make a report title or section label look tidy, but it is usually not a good way to organize the underlying data. Sorting and filtering work best when every record has a consistent row structure and values remain in separate cells. A merged cell spanning several rows can leave the table with blanks where a sorting or filtering operation expects values, and it can make selecting a rectangular data range less predictable.

For a heading that only needs to appear over several columns, consider leaving the cells unmerged and placing the heading in one cell, with suitable alignment and formatting. Another option is to use a dedicated title row above the data table. These approaches preserve the regular grid and reduce surprises when collaborators sort, filter, copy, or export the sheet. If the worksheet will be analyzed or imported into another system, keeping each value in its own cell is generally more useful than combining or merging it for appearance.

Frequently Asked Questions

Can Google Sheets merge cells without deleting text?
Not through the merge command alone. First join the contents into one string, move that result into the range’s top-left cell, and clear the other cells. Then merge. Otherwise, Sheets keeps only the top-left value.

How do I combine text from several cells in Google Sheets?
Use TEXTJOIN in a cell outside the source range. For example, with text in A2:C2, =TEXTJOIN(" ",TRUE,A2:C2) joins nonblank values with spaces. Copy the result and paste values only if you want to make it independent of the source cells.

What does Merge horizontally do?
It merges cells across each selected row. The value retained for each merged row comes from that row’s leftmost cell. It does not join text from the other cells in the row.

Can I undo a merge in Google Sheets?
Choose Format > Merge cells > Unmerge, or use Undo soon after merging. Unmerging restores the grid, but it does not bring back contents that the merge discarded. Version history or a separate copy may be needed to recover them.

How do I put each merged text value on a new line?
Join the source values with CHAR(10), move the result to the top-left cell, and enable Format > Wrapping > Wrap. The row may need extra height for all lines to be visible.

Google Sheets and Excel

The key behavior is similar in Google Sheets and Excel: merging is not the same as concatenating, and a merge does not preserve all the separate cell values. This article’s menu paths are for Google Sheets in a web browser; Excel has a different interface and its own merge controls. If you switch between the programs, treat the text-combining step and the cell-merging step as separate tasks in either one, and verify the final result before deleting the original data.

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.