
Excel TEXTBEFORE and TEXTAFTER Functions (SEVEN Examples)
In this video, we'll be discussing the Excel TEXTBEFORE and TEXTAFTER functions. The Excel TEXTBEFORE function extracts characters before a specific delimiter character in a text string, while the Excel TEXTAFTER function extracts characters after a specific delimiter character. The video will demonstrate seven examples of the the TEXTBEFORE and TEXTAFTER functions. These function are terrific and have made text manipulation much easier. 00:00 Introduction 01:15 TEXTBEFORE & TEXTAFTER syntax 01:56 TEXTBEFORE a delimiter character 02:25 TEXTBEFORE & TEXTAFTER together 03:55 Extract characters before a specific instance 06:02 Match End argument 07:11 If Not Found argument 08:07 TEXTAFTER function to return sheet name 09:56 Delimiter instance from end of string Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel