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. Learn ALL the best Excel functions - https://amzn.to/3Rg87Go 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 Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us! LinkedIn ► https://www.linkedin.com/in/alanmurray-computergaga/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1 #advancedexcelformulas #excel #excelfunctions