Topic 5: Manipulating Data in Excel with Text functions
Learn how to use legacy and new Microsoft 365 TEXT functions to extract, transform and shape text in Microsoft Excel.
In our fifth topic of our virtual Excel class, we cover LEFT, RIGHT, MID, UPPER, LOWER, PROPER to manipulate text.
We will also cover new TEXT functions including TEXTSPLIT, TEXTAFTER, TEXTBEFORE, UNIQUE, SORT and SORTBY.
Download workbook here for practice: https://drive.google.com/uc?id=1DWiap...
Chapters
0:00 Introduction
1:13 Legacy Text Functions
18:51 M365 Text Functions
29:24 UNIQUE Function
32:47 SORT and SORTBY