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

Excel would return ChristopherAiken to cell C3, all as one word.
After entering the concatenation formula that joins the first and last names in cell C3 separated by a single space, I then drag the Fill handle in cell C3 down to C17 to join all the other client names in a single cell in column C.
After the original concatenation formula is copied down the rows of column C, I copy the selected cell range C3:C17 to the Clipboard by clicking the Copy button in the Clipboard group of the Home tab on the Ribbon, and then I immediately choose the Paste Values option from the Paste command but- ton’s drop-down menu. This action pastes calculated text values over the concatenation formulas, thereby replacing the original formulas. The result is a list of first and last names together in the same cell in the range C3:C17, as though I had manually input each one.
Much Ado about Text 429
Book III Chapter 6
Lookup, Information, and Text Formulas