Description
Determines if the specified cell contains spaces only.
Syntax
ISEMPTY ( reference )
| Parameter | Description |
|---|---|
| reference | A reference to any cell |
Remarks
ISEMPTY returns #NULL! if the source value is null, TRUE if the source is blank or an empty string, and FALSE if the source is not blank or empty.
You may need to change formulas that use the ISEMPTY function to first check for a null source value.
Examples
IF( ISERROR( S1 ), TRUE, ISEMPTY( S1 ) )
This function returns True if S1 contains spaces only:
ISEMPTY(S1)
See also