Uploaded February 2026 | Updated September 2026, 2 weeks ago

---

Welcome to dptutorials, where Excel gets simpler and smarter.

In this video, you’ll learn how to use TEXTBEFORE and TEXTAFTER in Excel to extract text cleanly without using complicated LEFT, RIGHT, or MID formulas. These modern Excel functions make text extraction faster, easier, and far less error-prone.

This tutorial walks through real-world examples such as extracting names from email IDs, splitting product codes, separating invoice numbers, and cleaning imported data. TEXTBEFORE and TEXTAFTER work based on delimiters, so you no longer need to count characters or worry about changing text lengths.

A large real-world dataset with 50 examples is included so you can practice immediately. If you want to modernize your Excel skills and work faster with text data, this is a must-know Excel upgrade.

Subscribe to dptutorials for more Excel formulas, shortcuts, and real-world productivity tutorials.

TEXTBEFORE & TEXTAFTER in Excel | Stop Using LEFT & MID #shorts

#ExcelShorts
#ExcelTips
#ExcelFormulas
#ExcelTextFunctions
#dptutorials