Skip to main content
Version: Streamsheets 3.0

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

NameTypeDescription
TextStringA string for which to remove the not printable characters.
Extended (optional)BooleanA 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 value: FALSE

Return

TypeDescription
StringThe text without not printable characters.

Examples

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