
Try it!
You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.
Combine data with the Ampersand symbol (&)
-
Select the cell where you want to put the combined data.
-
Type = and then select the first cell you want to combine.
-
Next, type & and use quotation marks with a space enclosed.
-
Select the next cell you want to combine and then press enter. An example formula might be =A2&" "&B2.
Note: To combine the text from more than two cells, continue selecting cells, and typing &” “& after each cell you select. If you don’t want to add a space between the combined text, type & instead of &” “&. To add a comma, type &”, “& (a comma followed by a space, both enclosed in quotation marks).
Combine data using the CONCAT function
-
Select the cell where you want to put the combined data.
-
Type =CONCAT(.
-
Select the cell you want to combine first.
Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text.
-
Close the formula with a parenthesis and press Enter. An example formula might be =CONCAT(A2, " Family").