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

Name	Description
Text	A 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

Formula	Result	Comment
=CLEAN(CONCAT(CHAR(9), "Hello World", CHAR(10), CHAR(33)))	Hello World!