Microsoft Office Excel 2016: Part 2 (Intermediate) - This basic text functions let you manipulate text in cells to extract portions of text to other cells or combine them to produce e.g. full names or addresses. (The LEFT Function, The RIGHT Function, The MID Function)