Page 183 - Excel Workbook for Dummies

18_798452 ch13.qxp 3/13/06 7:53 PM Page 166
166 Part II: Using Formulas and Functions

9. Select OK to close the Function Arguments dialog box and enter the formula with
the CONCATENATE function in cell E3.
10. Copy the formula in cell E3 down to the cell range E4:E17 and then use AutoFit to
widen column E.
11. Replace the CONCATENATE formulas in the selected cell range E3:E17 by copy-
ing their values on top of their formulas using the Edit➪Paste Special command.
12. Edit the entries in E11 and E12, changing Mcavoy in cell E11 to McAvoy and
Mcclinton in cell E12 to McClinton.
13. Choose Window➪Arrange and then select the Vertical option button before you
select OK.
Excel now displays windows with parts of the Exercise13-2.xls workbook and
Solved13-1.xls workbook side by side.
14. Scroll the Text Function worksheet in the Exercise13-2.xls workbook so that
column F is visible in the window.
15. Click a cell in the Solved13-1.xls workbook to make it active and then scroll
column I into view and select the cell range I3:I17 (containing the joined
addresses).
16. Hold down the Ctrl key and position the mouse pointer somewhere along the
bottom of edge of the cell selection. Drag the outline of the selection from the
Text Formulas worksheet in the Solved13-1.xls workbook to the cell range F3:F17
in the Text Functions worksheet in the Exercise13-2.xls workbook. When the out-
line fills the cell range F3:F17 in this worksheet, release the mouse button.

17. Click a cell in Text Formulas worksheet in the Solved13-1.xls workbook to acti-
vate it and then close the workbook by clicking its Close button in the upper-
right corner of the program window without saving your changes.
18. Click the Maximize button in the upper-right corner of the Exercise13-2.xls
workbook.
19. Use the AutoFit feature to widen column F in the Text Functions worksheet.
20. In cell G3, use the CONCATENATE function to join the first and last name in cell
E3 with the address information in cell F3, making sure to add a comma and trail-
ing space after the last name.

21. Copy the formula in cell G3 down to the cell range G4:G17 and then widen
column G and scroll the worksheet as needed to completely display the names
and addresses in this range on your screen.
22. Replace the formulas in the cell range G3:G17 with their text values and then sort
the selection with the Sort Ascending button on the Standard toolbar.
23. Check your results against those shown in Figure 13-2. If they match, proceed to
the final step.
24. Select cell A1 and then save your work in a new workbook named Solved13-2.xls
in your Chapter 13 folder inside the My Practice Spreadsheets folder. Close the
workbook file and exit Excel.