4/19/25

New TEXT Functions in Excel 365

Microsoft 365 has introduced a set of exciting new text functions to level up your Excel skills! 🔥 In this tutorial from Tryit Learnit, we explore the power of TEXTBEFORE, TEXTAFTER, and TEXTSPLIT—each designed to make text extraction and transformation easier than ever.

We’ll walk through:

  • What each new function does

  • How to extract text before or after a character or string

  • How to split text into columns or rows without complex formulas ✂️

  • A peek at how to enable the Beta Channel to test new features early 🧪

📌 Perfect for data cleaning, form parsing, and spreadsheet automation!

💡 Want early access to new Excel functions? Sign up for the Office Insider Beta Channel through Excel → File → Account → Office Insider.

📺 Watch until the end for a bonus formatting tip—and a personal moment where a stray hair becomes the real distraction 😅

Previous

Rearrange Excel Columns with XLOOKUP

Next

Calculate Expiration Dates in Excel