Merge cells using CONCAT

1. Select the cell to put the combined data, and type =CONCAT.

2. Select the cell with the content you want to appear first.

3. Enter a comma, then select the second cell with information you want to add.

4. On your keyboard, press Enter.
   
   

Tip: You can also use the TEXTJOIN function.

To merge and center cells without preserving data, see Combine cells.

1. Select the cell to put the combined data, and type =CONCAT.

2. Select the cell with the content you want to appear first.

3. Enter a comma, then select the second cell with information you want to add.

4. On your keyboard, press Enter.

Tip: You can also use the TEXTJOIN function.

To merge and center cells without preserving data, see Combine cells.

1. Select the cell to put the combined data, and type =CONCAT.

2. Select the cell with the content you want to appear first.

3. Enter a comma, then select the second cell with information you want to add.

4. On your keyboard, press Enter.

Tip: You can also use the TEXTJOIN function.

To merge and center cells without preserving data, see Combine cells.