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.
Table of Contents
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.
