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

426 Much Ado about Text
Excel now copies the formula =PROPER(B3) to cell D3, which now contains the proper capitalization of the first name, Christopher. Now you’re ready to copy these formulas with the PROPER function down to row 17.
4. Drag the fill handle in the lower-right corner of cell D3 down to cell D17 and then release the mouse button to copy the formulas with the PROPER function down.
The cell range C3:D17 now contains first and last name text entries with the proper capitalization. (See Figure 6-5.) Before replacing all the upper- case entries in A3:B17 with these proper entries, you convert them to their calculated values. This action replaces the formulas with the text as though you had typed each name in the worksheet.
5. With the cell range C3:D17 still selected, click the Copy command button on the Home tab of the Ribbon.
Figure 6-5:
Using the PROPER function
to convert names in all uppercase letters to proper capi- talization.