NEW EXCEL TEXT FUNCTIONS - Easily Separate Text
In this step-by-step Microsoft Excel tutorial, you will learn how to use Excel's recently released new text functions, TEXTBEFORE, TEXTAFTER and TEXTSPLIT.
►COURSES
My courses to advance your professional career ►https://www.the-excel-team.com/
20% off any course – use code YOUTUBE
►Timestamps:
00:00 New Excel Functions
00:29 TEXTBEFORE & TEXTAFTER - The Basics
01:52 TEXTBEFORE & TEXTAFTER - Delimiter Position
05:13 TEXTBEFORE & TEXTAFTER - Multiple Delimiters
06:26 TEXTBEFORE & TEXTAFTER - Error Handling
07:13 TEXTSPLIT - The Basics
08:45 TEXTSPLIT - Ignore Empty Cells
09:58 TEXTSPLIT - Rows & Columns
10:48 TEXTSPLIT - Error Handling
12:18 Final Words
►VIDEO RESOURCES
Download the excel workbook from this video: https://www.the-excel-team.com/course...
►THE GEAR I USE
Camera: https://amzn.to/3SGHZqe
Lens: https://amzn.to/3A9EH7s
Camera + Lens Kit: https://amzn.to/3p6M74Z
Shotgun Mic A: https://amzn.to/3JEX1sn
Shotgun Mic B: https://amzn.to/3BPimgM
Desktop Mic: https://amzn.to/3A96rJl
Mouse: https://amzn.to/3A97R6J
Keyboard: https://amzn.to/3pbD16Y
Monitors: https://amzn.to/3p3XquP
Chair: https://amzn.to/3QiWX48
All products I use/recommend: https://www.amazon.com/shop/the.excel...
►CONNECT WITH ME
Contact me - Email: [email protected]
Website: https://www.the-excel-team.com/
Instagram: https://www.instagram.com/the.excel.t...
Tiktok: / the.excel.team
Note: The description of this video contains affiliate links. If you would like to support the channel and are already interested in one of the mentioned products, please consider using the links. The channel will receive a small monetary commission at no extra cost to you, but will help to bring more videos like this to you in the future.
Thank you for your support!