Text Manipulations with Excel's TEXTBEFORE & TEXTAFTER functions
Textbefore Textafter Excel functions are one of 14 new functions released in March 2022 for extracting text before and after a delimiter in Excel. The video shows examples of TextBefore and TextAfter functions
Workbook link:
https://drive.google.com/file/d/1ioa4...
00:00 introduction
01:03 TEXTBEFORE_TEXTAFTER arguments
02:28 First example of the functions
04:16 Match mode/Ignore case example/description
06:05 Match End argument example/description
08:30 Split first names and last names
11:45 Extract filename or sheet names from full file path
14:50 List of all sheets in workbook
16:27 Sort Full names by last name
19:15 Extract names when delimiter is an uppercase
22:02 Final example(Nesting TextBefore/TextAfter)