Exam 77-420 Microsoft Excel 2013 4. Apply Formulas and Functions 4.4 Format and Modify Text with Functions: Use the RIGHT, LEFT and MID Functions

Modify Text with Functions There are several TEXT functions that every programmer should have in their skill set: RIGHT, LEFT, MID, and TRIM. These functions let you select part of a STRING. In the first example the LEFT function will select the first three letters of the Month in Column A (January, February, etc.)   2. Try it: Find the LEFT function The Original Data spreadsheet is still open. Select Cell J1. Type the label: Left. Select Cell J2. Go to Formulas ->Function Library->Text. Click on : LEFT. The LEFT Function Arguments should open. Keep going.... Formulas ->Function Library-> Text->LEFT