How to Fix the #NAME Error in Excel

In this tutorial, you will learn how to fix the #NAME error in Excel.

Even if you’re only inserting a ‘space’, you must enclose the text in quotation marks when you mention it in a formula. The #NAME error will appear if the syntax for a text value does not include double quote marks, “”.

Once ready, we’ll get started by utilizing real-world examples to show you how to fix the #NAME error in Excel.

Fix the #NAME Error

Before we begin we will need a group of data to fix the #NAME error in Excel.

Method 1 : Check Function Name

As you can see, the reason for the formula to return #NAME? Is because we have wrongly spelt ‘AVERAGE’.

Once you correct the spelling, the formula will return the correct answer.

Method 2 : Not Inserting Colon in Formula

In this example, we are looking for how many times did ‘A’ appear in the data group. However, due to the exclusion of a colon in the range we want to find, the formula has returned #NAME?.

We can simply fix this by inserting ‘:’ in the formula for the range.

Method 3 : Not Inserting Quotation Mark in Formula

In this example, we want to combine all the data in the group into one cell. However, the formula has returned #NAME? As we have missed out inserting the “” infront and behind ‘and’.

To fix this, we can simply add quotation marks.