Replace Formulas Error Messages with Zero, Blank Cells, or Text in Excel!!
Tags: kutoolsexceltutorial, stepstoreplaceformul, kutools
Published: 2020-10-22 12:15:52

---
title: Replace Formulas Error Messages with Zero, Blank Cells, or Text in Excel!!
published: true
date: 2020-10-22 07:17:50 UTC
tags: KutoolsExcelTutorial,StepstoReplaceFormul,Kutools
canonical_url: https://geekexcel.com/replace-formulas-error-messages-with-zero-blank-cells-or-text-in-excel/
---

In this article, we are going to see how to **Replace Formulas Error Messages with Zero, Blank Cells, or Text in Excel Office 365** using **Kutools.** Let’s get into this article!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Replace Errors with Zero/Blank Cells/Text:

To do this, you need to follow the below instructions.

- Go to the **Kutools Tab, select** the **More** option, **choose** the **Error Condition Wizard** option from the drop-down list.

![Select the Error Condition Wizard option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-Error-Condition-Wizard-option.png)<figcaption id="caption-attachment-16175">Select the Error Condition Wizard option</figcaption>

- Now, it will display the **Error Condition Wizard Dialog Box**.
- **Range – ** In this section, you need to **select the input range** using the given browse button.
- **Error types – ** You need to choose the error type that you want to replace. It can be **any error value** , **only**  **the #N/A Error value** , or **any error value except #N/A error value**.
- **Error display – ** You need to specify any one of the options to display instead of errors. Here, we have given the text “ **Excel** ” to replace the error values.
- Finally, **hit** the **OK** button.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Click-the-OK-button-3.png)<figcaption id="caption-attachment-16176">Click the OK button</figcaption>

- You can see that all the errors are replaced with the specified text as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Result-33.png)<figcaption id="caption-attachment-16177">Result</figcaption>

### Note:

- You can replace the Error messages with the below-given messages.
- **Nothing (a blank cell)** – It is used to replace errors with empty cells.
- **A message (text)** – You can enter any text in the given box to replace errors with.
- **A cell reference** – An [absolute reference](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/) replaces the errors.

## Verdict:

In this short article, you can clearly understand the steps to **Replace Formulas Error Messages with Zero, Blank Cells, or Text in Excel Office 365** using **Kutools ** with an example. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [Excel Formulas to Extract the Nth Word from a Text String!!](https://geekexcel.com/excel-formulas-to-extract-the-nth-word-from-a-text-string/)
- [How to Fix #VALUE! Error in Excel Office 365? – [with Example]](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/)