Excel TEXTBEFORE and TEXTAFTER Functions (SEVEN Examples)
4.4 هزار بار بازدید -
پارسال
-
In this video, we'll be
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 ► LinkedIn: alanmurray-computergaga
Instagram ► Instagram: computergaga1
Twitter ► Twitter: computergaga1
#advancedexcelformulas #excel #excelfunctions
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 ► LinkedIn: alanmurray-computergaga
Instagram ► Instagram: computergaga1
Twitter ► Twitter: computergaga1
#advancedexcelformulas #excel #excelfunctions
پارسال
در تاریخ 1402/01/30 منتشر شده
است.
4,463
بـار بازدید شده