Excel TEXTBEFORE and TEXTAFTER to Extract Data from Strings - Video

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 game-changers.

Here's what I cover:

* TEXTBEFORE function: Learn how to isolate text segments before a specific delimiter in Excel, with hands-on 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 how-to; it's about expanding your Excel toolkit to tackle real-world 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

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