Split Columns Like a Pro in Power Query! Custom Splitter Function

In this Power Query tutorial, I’ll show you how to separate numbers and text automatically — even when there’s no clear delimiter! Instead of using a normal split by character, you’ll learn how to split based on the transition from digits to non-digits (and vice versa) using a custom M splitter function. In this step-by-step guide, we’ll cover: 🔹 How to identify digit ↔ non-digit boundaries in text 🔹 How to use and modify Splitter.SplitTextByCharacterTransition 🔹 How to separate values like 20241012ProductA25 into Date, Product, and Quantity 🔹 How to clean, rename, and expand new columns after splitting This technique is perfect when your data isn’t clean or doesn’t include consistent separators — great for Power BI and Excel Power Query users! 👉 Don’t forget to subscribe for more Power Query & Power BI tutorials every week! #PowerQuery #PowerBI #ExcelPowerQuery #DataTransformation #MCode #SplitColumn #CustomSplitter #SplitByDigits #PowerQueryTips #ETL 00:00 Introduction 00:20 Splitter function 01:20 modifying the function 02:40 modifying the column titles