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 ► / alanmurray-computergaga
Instagram ► / computergaga1
Twitter ► / computergaga1
#advancedexcelformulas #excel #excelfunctions
Watch video Excel TEXTBEFORE and TEXTAFTER Functions (SEVEN Examples) online without registration, duration hours minute second in high quality. This video was added by user Computergaga 19 April 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 4,98 once and liked it 14 people.