Skip to main content
Version: Streamsheets 2.3

CLEAN

Removes all nonprintable characters from given string. Note: by default CLEAN removes only the characters corresponding to ASCII code 0 to 31. To remove characters with ASCII code 127, 129, 141, 143, 144 and 157 set the optional extended flag to true.

Syntax

=CLEAN(Text, [Extended])

Arguments

NameDescription
TextA string for which to remove the nonprintable characters.
ExtendedOptional. A boolean flag which indicates that the characters which correspond to the ASCII codes 127, 129, 141, 143, 144 and 157 should be removed too. Default is false.

Return Value

The text without nonprintable characters.

Example

FunctionResult
=CLEAN(CONCAT(CHAR(9), "Hello World", CHAR(10), CHAR(33)))Hello World!