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	Type	Description
Text	String	A string for which to remove the not printable characters.
Extended (optional)	Boolean	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 value: FALSE

Return

Type	Description
String	The text without not printable characters.

Examples

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