IsSpaces Function

Check if a string expression is either empty or contains only space characters.

IsSpaces (String)

Parameters

String  -  (Input, String expression, Required)

Specifies the string to be evaluated.

Return Value

Returns True if the string is empty, or contains only spaces, otherwise False is returned. Null is not counted as an empty string.

Examples

IsSpaces (“”)	Returns True
IsSpaces (“ ”)	Returns True
IsSpaces (“ a”)	Returns False
IsSpaces (Null)	Returns False
IsSpaces (Error)	Returns False

TIP:

Functions are specifically for use in the Macro Editor. Refer to Microsoft's official VB and JScript documentation for scripting equivalents.

See Also

UBound Function | IsArray function | IsDate function | IsEmpty function | IsError function | IsNull function | IsNumeric function | IsSpaces function | IsURL function

---

© 2004-2021 looksoftware. All rights reserved.