Using the LEFT and RIGHT Functions - Exercise

Contact Us or call 1-877-932-8228
Using the LEFT and RIGHT Functions - Exercise

Using the LEFT and RIGHT Functions

Duration: 5 to 15 minutes.

In this exercise, you will practice using the LEFT and RIGHT functions.

  1. Open Functions.xlsx from your Excel2013.2/Exercises folder and go to the sheet named "LEFT-RIGHT".
  2. In column B, use the LEFT function to display only the area codes of the phone numbers listed in column A.
  3. In columns E and F, use the LEFT and RIGHT functions to display the Store IDs and Salesperson IDs for the sales listed in column D.

Solution:

  1. To display only the area codes of the phone numbers listed in column A:
    1. In the sheet named "LEFT-RIGHT", select cell B2.
    2. On the FORMULAS tab, in the Function Library group, click the Insert Function command:Insert Function in Function Library Group of Formulas Tab
    3. In the Insert Function dialog box:
      1. Search on "LEFT" or, in the Or select a category drop-down box, select Text.
      2. Under Select a function, select LEFT.
      3. Click OK.Insert Function Dialog Box
    4. In the Function Arguments dialog box:
      1. In the Text field, enter cell A2.
      2. In the Num_Chars field, enter the number "3".
      3. Click OK.Function Arguments Dialog Box
    5. Copy cell B2 to cells B3:B7.
  2. To display the Store IDs for the sales listed in column D:
    1. In the sheet named "LEFT-RIGHT", select cell E2.
    2. On the FORMULAS tab, in the Function Library group, click the Insert Function command.
    3. In the Insert Function dialog box:
      1. Search on "LEFT" or, in the Or select a category drop-down box, select Text.
      2. Under Select a function, select LEFT.
      3. Click OK.
    4. In the Function Arguments dialog box:
      1. In the Text field, enter cell D2.
      2. In the Num_Chars field, enter the number "3".
      3. Click OK.Function Arguments Dialog Box
    5. Copy cell E2 to cells E3:E7.
  3. To display the Salesperson IDs for the sales listed in column D:
    1. In the sheet named "LEFT-RIGHT", select cell F2.
    2. On the FORMULAS tab, in the Function Library group, click the Insert Function command.
    3. In the Insert Function dialog box:
      1. Search on "RIGHT" or, in the Or select a category drop-down box, select Text.
      2. Under Select a function, select RIGHT.
      3. Click OK.Insert Function Dialog Box
    4. In the Function Arguments dialog box:
      1. In the Text field, enter cell D2.
      2. In the Num_Chars field, enter the number "2".
      3. Click OK.Function Arguments Dialog Box
    5. Copy cell F2 to cells F3:F7.
Next