Page 446 - Excel 2013 All-in-One For Dummies

428 Much Ado about Text Concatenating text
You can use the ampersand (&) operator to concatenate (or join) separate text strings together. For example, in the Client list spreadsheet shown in Figure 6-6, you can use this operator to join together the first and last names currently entered in two side-by-side cells into a single entry, as shown in Figure 6-7.
To join the first name entry in cell B3 with the last name entry in cell A3, I entered the following formula in cell C3:
=B3&” “&A3
Notice the use of the double quotes in this formula. They enclose a blank space that is placed between the first and last names joined to them with the two concatenation operators. If I didn’t include this space in the formula and just joined the first and last names together with this formula
=B3&A3
Figure 6-7:
Spreadsheet after concat- enating the first and last names in column C.