There are two ways to merge cells in Google Sheets. To learn how to do so, select a link below and follow the steps.

Merge two or more cells using the Merge cells feature

In Google Sheets, you can merge two or more cells using the “Merge cells” feature.

  • Merge two or more cells using the Merge cells feature.

  • Merge two or more cells using a formula.

  • Access the Google Sheets website and open a new or existing spreadsheet.

  • Highlight two or more adjacent cells you want to merge. For example, highlight cells A1 and B1 or C1 and C2.

  • How to select one or more cells in a spreadsheet program.

  • Click the Merge cells option in the formatting bar.

Merge two or more cells using a formula

In Google Sheets, you can merge two or more cells using a formula. Utilizing an ampersand (&) in a formula acts to combine the values in cells together.

When cells with multiple values are merged, the upper-right most cell becomes the data of the merged cell.

In this example, the formula =A1&B1 combines the values in cells A1 and B1 to cell C1. In this same example, to add a space between the two cell values, include a “space” in it (e.g., =A1&" “&B1). You would use double quotes around a space to add a space in the formula and the resulting merged value.

To combine more than two cells, add each cell to the formula, using an ampersand (&) between each cell reference. For example, to combine cells A1, B1, C1, and D1, use the formula =A1&B1&C1&D1.

  • How to combine cell values in Excel.
  • How to split an Excel cell using the Text to Columns function.
  • See the cell, merge, and split definitions for further information and related links.
  • Google Sheets help and support.