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.

You can also combine data using an ampersand (&).

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.

You can also combine data using an ampersand (&).