Dive into two powerful Excel functions: TEXTBEFORE and TEXTAFTER, exclusive to Microsoft 365. In this tutorial, I'll guide you through the basics and then skillfully combine both functions to master text manipulation. Whether you're sorting through lists of locations or dissecting product numbers, these functions are gamechangers.

Here's what I cover:

* TEXTBEFORE function: Learn how to isolate text segments before a specific delimiter in Excel, with handson examples.
* TEXTAFTER function: Flip the script and extract text following your chosen delimiter, understanding the function's versatility.
* Combine TEXTBEFORE and TEXTAFTER: Discover how to nest these functions to capture the essence of text lying in the middle of your data strings.
* Using the FORMULATEXT function: Keep track of the formulas applied

This tutorial isn't just about the howto; it's about expanding your Excel toolkit to tackle realworld data manipulation challenges, from accounting figures to product codes.

Excited for more Excel mastery? Subscribe for updates on my online training classes, covering everything from the basics to advanced techniques, and get a sneak peek at my upcoming classes on Microsoft Copilot and Microsoft Teams:
https://courses.chrismenardtraining.com

Chapters:
00:00 Introduction
00:32 Demonstrating TEXTBEFORE Function
01:34 Exploring TEXTAFTER Function
02:04 Combining TEXTBEFORE and TEXTAFTER for Advanced Usage
03:56 Conclusion and additional resources

Blog post https://chrismenardtraining.com/post/...

And make sure you subscribe to my channel!

EQUIPMENT USED
○ My camera – https://amzn.to/3vdgF5E
○ Microphone https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights https://amzn.to/3vaxyy5
○ Dual monitor mount stand https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount https://amzn.to/3g96FGj
○ Boom Arm https://amzn.to/3g8cNi6

SOFTWARE USED
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

#excel #chrismenard #excelfunctions