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

Much Ado about Text 427
6. Immediately choose the Paste Values option from the Paste command
button’s drop-down menu.
You’ve now replaced the formulas with the appropriate text. Now you’re ready to move this range on top of the original range with the all-upper- case entries. This action will replace the uppercase entries with the ones using the proper capitalization.
7. With the cell range C3:D17 still selected, position the white-cross mouse or Touch pointer on the bottom of the range; when the pointer changes to an arrowhead, drag the cell range until its outline encloses the range A3:B17 and then release the mouse button or remove your finger or stylus from the touchscreen.
Excel displays an alert box asking if you want the program to replace the contents of the destination’s cells.
8. Click OK in the Alert dialog box to replace the all-uppercase entries with the properly capitalized ones in the destination cells.
Your worksheet now looks like the one shown in Figure 6-6. Everything is fine in the worksheet with the exception of the two last names, Mcavoy and Mcclinton. You have to manually edit cells A11 and A12 to capitalize the A in McAvoy and the second C in McClinton.
Figure 6-6:
Worksheet after replacing names in all uppercase letters with properly capitalized names.
Book III Chapter 6
Lookup, Information, and Text Formulas