To combine cell contents using the Ampersand (&) symbol, follow these steps:
Select the cell where you want the combined text to appear.
Type
=and then click on the first cell you want to combine (e.g., a person's first name).Add
&" "&to insert a space between the names.Click the second cell you want to combine (e.g., a person's last name) and press Enter.
For example, use the formula =A2&" "&B2 to join a first name in cell A2 with a last name in cell B2.
TIP: To combine text from more than two cells, continue adding &" "& after each cell selection to include spaces between texts. If you prefer not to have spaces, use & alone. For a comma and a space between texts, use &", "&. This method allows you to customize the separators between combined cell contents as needed.
