Skip to main content
Version: Streamsheets 2.5

CLEAN

Removes all not printable 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 not printable characters.
Extended (optional)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

The text without not printable characters.

Examples

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