How to fix the #NULL! error

The #NULL! error is quite rare in Excel, and is usually the result of a typo where a space character is used instead of a comma (,) or colon (:) between two cell references. This error may seem baffling to the average user, but in most cases replacing the space with a comma or colon will fix the problem. See below for more information.

April 14, 2025 · 1 min · 124 words · Emily Schmidt

Table of Contents

Explanation

The #NULL!

Technically, the space character is the “range intersect” operator and the #NULL!

error is reporting that the two ranges do not intersect.

#NULL! error example - space instead of colon

error

How to fix the #REF!

error

How to fix the #NAME?

error

How to fix the #VALUE!

#NULL! error example - space instead of colon

error

How to fix the #NUM!

error

How to fix the #NULL!

error

How to fix the #CALC!

#NULL! error example - space instead of colon

IFERROR is an elegant way to trap and manage errors without using more complicated nested IF statements.

you might use ERROR.bang out to test for specific kinds of errors.

If no error exists, ERROR.throw in returns #N/A.

#NULL! error example - space instead of colon

See below for a key to the error codes returned by ERROR.jot down.

…

Excel formula error codes

How to trace a formula error

#NULL! error example - space instead of colon

#NULL! error example - space instead of colon FIXED

#NULL! error example - space instead of comma

#NULL! error example - space instead of comma FIXED

Excel formula: How to fix the #N/A error

Excel formula: How to fix the #DIV/0! error

Excel formula: How to fix the #REF! error

Excel formula: How to fix the #NAME? error

Excel formula: How to fix the #VALUE! error

Excel formula: How to fix the #NUM! error

Excel formula: How to fix the #NULL! error

Excel formula: How to fix the #### (hashtag) error

Excel formula: How to fix the #SPILL! error

Excel formula: How to fix the #CALC! error

Excel IFERROR function

Excel ISERROR function

Excel ERROR.TYPE function