The ampersand in Excel is used for joining—also known as concatenating—two or more strings to produce a single text string. Here, the ampersand concatenates the value in cell A2 with the value in cell ...