Using the CONCATENATE Function - Exercise

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

Using the CONCATENATE Function

Duration: 10 to 15 minutes.

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

  1. Open Functions.xlsx from your Excel2013.2/Exercises folder and go to the sheet named "CONCATENATE".
  2. Use the CONCATENATE function to join the first and last names into full names in column C.
  3. Use the CONCATENATE function to join the cities and states so that they appear as "city, state".

Solution:

  1. To join the first and last names into full names:
    1. In the sheet named "CONCATENATE", select cell C2.
    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 "CONCATENATE" or, in the Or select a category drop-down box, select Text.
      2. Under Select a function, select CONCATENATE.
      3. Click OK.
    4. In the Function Arguments dialog box:
      1. In the Text1 data entry field, enter cell A2.
      2. In the Text2 data entry field, enter a space (" ").
      3. In the Text3 data entry field, enter cell B2.
      4. Click OK.
    5. Copy cell C2 to cells C3:C7.
  2. To join the cities and states so that they appear as "city, state":
    1. In the sheet named "CONCATENATE", select cell G2.
    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 "CONCATENATE" or, in the Or select a category drop-down box, select Text.
      2. Under Select a function, select CONCATENATE.
      3. Click OK.
    4. In the Function Arguments dialog box:
      1. In the Text1 data entry field, enter cell E2.
      2. In the Text2 data entry field, enter a comma and a space (", ").
      3. In the Text3 data entry field, enter cell F2.
      4. Click OK.
    5. Copy cell G2 to cells G3:G7.
Next