Power Query Advanced Replacer: Replace Whole Cells with Null Using Custom Functions

In this video, you’ll learn how to build and use an advanced custom replacer function in Power Query to automatically replace entire cells with null whenever they contain specific unwanted text. Using a function like: (a, b, c): if Text.Contains(a, b) then null else a you can create powerful dynamic cleaning logic that works across any column and for any search text. You’ll discover: 🔹 Why custom replacer functions are stronger than standard "Replace Values" 🔹 How to use the (a,b,c)=.. pattern to control replacement logic 🔹 How to replace the entire cell, not just part of the text 🔹 How to combine it with: Table.TransformColumns Table.ReplaceValue 🔹 How this approach saves time when working with messy datasets 🔹 Real-world examples for Power BI & Excel Power Query Perfect for anyone doing data cleaning, ETL processes, or building automated Power BI reports. 00:00 Introduction 01:29 Solve the problem by adding a new column 03:12 Replacer function