Excel #NAME?: Separate Formula Names, Cell References and Literal Text

#NAME? means Excel cannot resolve something in the formula’s syntax. A misspelled function, undefined name or unquoted text can cause it. Microsoft explicitly advises correcting the syntax rather than hiding this error with IFERROR. See its NAME error reference.

Decide what each token is supposed to mean

Preserve the original formula. In a scratch copy, identify each function name, cell address, named reference and literal text value. These are different roles: A2 means a cell, while "A2" means the two-character text label.

Check function spelling against its reference. For a named reference, establish which input it was intended to represent before replacing it with an address. Do not create a new name pointing to a guessed cell just to remove the error. If the formula came from another workbook or edition, record that origin for further investigation.

Controlled example: a label is not a named range

Use a new practice sheet with no defined name called Crates. Enter numeric 14 in A2. In B2 enter:

=Crates&": "&A2

Because Crates is not defined, the documented expected outcome is #NAME?. If the intended output is a label followed by the quantity, correct the formula to:

="Crates: "&A2

The independently derived expected text is Crates: 14. Change A2 to 19; expect Crates: 19. The second check confirms the quantity still comes from A2 rather than being hard-coded into the label. Microsoft’s Excel-for-the-web formula overview documents text constants, references and the ampersand operator.

If Crates was actually supposed to be a named input, adding quotation marks would change the calculation’s meaning instead of repairing that reference. Determine the intended role first.

Check the repaired meaning

A missing range colon is another documented cause. Compare the intended start and end addresses, not just the absence of an error. After repairing a real formula, test one known input change and reconcile the expected output. Keep unresolved formulas visible rather than replacing them with blank text.

For a desktop name-management walkthrough, use named ranges, whose Windows scope is separate. For other error labels, return to the error reference.

Scope and evidence

Checked October 22, 2026 for basic typed formulas in Excel for the web. The example uses English syntax and straight double quotes; no desktop Name Manager or add-in controls are assumed. Expected text and documented error classification were independently checked, not executed in Excel. No screenshot, account access or paid application was used.