Using the PROPER Function - Exercise

Contact Us or call 1-877-932-8228
Using the PROPER Function - Exercise

Using the PROPER Function

Duration: 5 to 10 minutes.

In this exercise, you will practice using the PROPER function.

  1. Open Functions.xlsx from your Excel2013.2/Exercises folder and go to the sheet named "PROPER".
  2. In column B, use the PROPER function to capitalize the first letters of the names in column A.

Solution:

  1. To capitalize the first letters of the names in column A:
    1. In the sheet named "PROPER", select cell B2.
    2. On the FORMULAS tab, in the Function Library group, click the Insert Function command:Insert Function Command
    3. In the Insert Function dialog box:
      1. Search on "PROPER" or, in the Or select a category drop-down box, select Text.
      2. Under Select a function, select PROPER.
      3. Click OK.PROPER Function
    4. In the Function Arguments dialog box:
      1. In the Text data entry field, enter A2.
      2. Click OK.OK Option
    5. Copy cell B2 to cells B3:B7.
Next