'Video thumbnail for Excel TEXTBEFORE and TEXTAFTER Functions (SEVEN Examples)'

Excel TEXTBEFORE and TEXTAFTER Functions (SEVEN Examples)

2K views May 15, 2023

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

#Computer Education
  # Educational Software