Filter by Categories
Select all
Business Statements
Federal Income Tax
Gantt Chart
GST India
Health, Logs and Personal Trackers
Invoice/ Bill
Payroll & HR
Project Reports & Timelines
Purchase Order/Requisition
Rental Ledger
Risk Registers
Sales/ Marketing
SWOT Analysis
Timesheet/ Attendance
Filter by File Types

How to replace or remove errors in Power Query Editor ?

How to replace or remove error(s) in Power Query Editor

Introduction to Power Query

Power Query is a data transforming engine which you can use to get data from multiple sources, clean and transform that data and then use it further in the analysis.

Replace or remove errors in Power Query

Normally for replacing or removing errors in Excel you can use find and replace option or a VBA code. But in power query, it’s a whole lot easier. Look at the below column where you have some errors and you can remove as well as replace them.

When you right-click on the column, you’ll have both of the options.

  • Replace Errors
  • Remove Errors

Other Examples of Power Query tool in MS Excel 

Below is the list of examples of using Power Query tool in MS Excel, you can learn and master each examples –


Macro Codes in Excel

Learn Excel Quickly
Get full list of Excel Macro Codes