How to Join Two Cells in Google Sheets: Merge Cells

To join two adjacent cells in Google Sheets, select them, then choose Format > Merge cells and pick the appropriate merge option. Merging makes the cells act as one larger cell, but it keeps only the value in the upper-left cell. If you want to put both cells’ contents together without removing either original value, use a formula or copy the results elsewhere instead. The steps below explain both options so you can choose the one you need.

What You’ll Need

You can do this in Google Sheets in a web browser. Before merging, check what is in each selected cell: any content outside the upper-left cell will be removed by the merge.

A Google Sheets spreadsheet with the cells you want to merge or combine.
Edit access to the spreadsheet if you need to change its contents.
If you want to combine text rather than merge the cells, an empty cell where you can place the combined result.

Step-by-Step

Use the first set of steps to physically merge two neighboring cells. Use the alternative near the end if “join” means combining the values while keeping the cells separate.

Open the spreadsheet and locate the cells. Find the two cells you want to join. They must be next to each other in the same row or column. For example, A1 and B1 are side by side; A1 and A2 are one above the other. Google Sheets merges a continuous rectangular selection, not two separate, non-adjacent cells.
Check the contents before selecting. Click each cell and look at its value in the cell and formula bar. A merge keeps the value from the upper-left cell of the selected range and removes values in the other cells. If you need both values, copy them somewhere safe or use the text-combining method in step 7 before merging.
Select exactly the cells to merge. Click the first cell, then drag across the other cell or cells. You can also click the first cell, hold Shift, and click the last cell in the range. Confirm that the highlighted area is only the intended pair. For a horizontal pair select, for example, A1:B1; for a vertical pair select A1:A2.
Open the merge commands. In the Google Sheets menu bar, click Format, point to Merge cells, and wait for the submenu. If the menu option is unavailable, check that you have selected a suitable continuous range and that you can edit the sheet.
Choose the right merge option. For two cells in one row, choose Merge horizontally. For two cells in one column, choose Merge vertically. If the selection is a rectangular block and you want it to become one cell, choose Merge all. The options available depend on the shape of your selection.
Check the merged result. The selected cells should now appear as one larger cell. Click it and confirm that the displayed value is the one you intended to keep. Merging changes the cell layout; it does not combine two separate text values into a sentence. If the wrong content remains, use Edit > Undo immediately, then save or copy the values before trying again.
Combine text instead if both values matter. Leave the original cells unmerged and enter a formula in an empty cell. With Grace in A1 and Hopper in B1, enter =A1&" "&B1 in C1. The result is Grace Hopper, with a space between the names. This formula creates a combined display value in C1; it does not change A1 or B1 or physically merge any cells.
Finish by checking how the result will be used. If the merged cell is a heading, check that the text is readable and the layout looks right. If the values are data you need to sort, filter, calculate with, or export, keeping them in separate cells is usually more practical. In Excel for Microsoft 365, the comparable commands are under Home > Merge & Center, rather than Google Sheets’ Format > Merge cells menu.

Common Mistakes

Assuming a merge combines the text. Merging changes the shape of the selected cells; it is not the same as joining their contents. If A1 says “Grace” and B1 says “Hopper,” merging A1:B1 keeps “Grace” and discards “Hopper.” Use a formula in another cell when you need both words in one result.

Selecting a larger range than intended. A drag can include an extra row or column. Before choosing a merge command, look at the highlighted range and its boundaries. If you select A1:C1 instead of A1:B1, the third cell will be part of the merge too, and its value may be removed.

Choosing the wrong direction. Merge horizontally is for cells across a row; merge vertically is for cells down a column. If the menu choice does not match the selection’s shape, the command may be unavailable or the result may not be what you expected. Select the pair again and choose the option that matches its orientation.

Expecting unmerge to restore deleted values. Unmerging returns the area to separate cells, but it does not bring back values that were removed during the merge. Undo is the best immediate recovery if the merge just happened. Otherwise, restore the missing content from a copy, revision history, or another source.

Tips

Keep a backup of important contents. Copy the values to another range or duplicate the sheet before merging cells that contain information you cannot easily recreate. This is especially useful when you are working with a shared sheet or an unfamiliar template.
Use merged cells mainly for presentation. Merging can make a title span several columns, but it can make a table harder to sort, filter, or use as a source for formulas. For a table heading, consider placing the label in one cell and formatting the surrounding cells without merging.
Check the upper-left cell first. In any selected rectangular range, the value that survives is in the upper-left position. For a horizontal pair, that is the cell on the left; for a vertical pair, it is the top cell. Move the value you want to keep there before you merge.
Use a formula when the source values may change. The formula result updates when A1 or B1 changes, whereas copied-and-pasted text will not update automatically. If you need a fixed result, copy the formula cell and use Edit > Paste special > Values only to paste its displayed value, then check the result before removing any source data.
Plan for blank cells too. A blank cell does not cause a merge to combine content from another position. If the upper-left cell is blank and the other selected cell contains text, the blank upper-left value is retained and the text in the other cell is removed. Move the needed value first.

Troubleshooting

The Merge cells command is greyed out. First check whether you have selected a continuous range of neighboring cells. Separate cells cannot be merged together. If the range is valid, confirm that you have permission to edit the spreadsheet and that the sheet or selected range is not protected. If you only have view access, ask the owner for edit access or request that they make the change.

The wrong value appears after merging. Google Sheets retains the upper-left value, so the result may be expected even if it is not the content you wanted. If the change is still the latest action, choose Edit > Undo. Otherwise, unmerge if needed, then restore the missing value from revision history or a backup. For the next attempt, move the intended surviving value to the upper-left cell and preserve the other values before merging.

The merged cell shows only part of the text. The value may still be present even if the cell does not display all of it. Widen the column, increase the row height, or adjust text wrapping and alignment from the toolbar. Also check whether neighboring cells contain content that affects how text appears. Formatting can change visibility, but it will not recover a value that was removed by the merge.

The text-combining formula does not work. Make sure the formula is entered in a different cell from its source cells, starts with an equals sign, and refers to the correct addresses. The example assumes the names are in A1 and B1 and the formula goes in C1. If your values are elsewhere, replace those references. If the cell displays the formula as text instead of a result, check that its format is not set to plain text; change it to Automatic, then re-enter the formula.

The result looks joined but you still need separate data. A combined formula result and a merged cell solve different problems. Keep source data in separate cells for sorting or calculations, and use a formula only for a display value. If the layout alone is the goal, merge the cells only after confirming that removing the other cell contents is acceptable.

Frequently Asked Questions

Can I merge two cells that both contain text?
Yes, but only the value in the upper-left cell of the selected range remains. Copy the other value elsewhere first, or combine the text in a separate cell with a formula.

Can I undo a merge in Google Sheets?
Choose Edit > Undo right after merging to reverse the action. You can also select the merged cell and choose Format > Merge cells > Unmerge, but unmerging does not restore any values removed during the merge.

Can I merge cells in different rows?
You can merge neighboring cells vertically in one column, or merge a continuous rectangular range. You cannot select two unrelated cells in different rows and merge just those two while leaving the cells between them out.

How do I join the contents but keep both cells?
Use a formula in an empty cell. For values in A1 and B1, =A1&" "&B1 joins them with a space and leaves the originals in place. Change the space between the quotation marks if you want a different separator.

Will merging cells affect sorting and filtering?
It can make a data table harder to sort or filter, especially when merged cells span rows or columns. Keep each record in its own row and each field in its own column when you need structured data operations; reserve merges for layout areas such as titles.

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.