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

Name

Description

Text

A string for which to remove the nonprintable 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 Value

The text without nonprintable characters.

Example

Function

Result

=CLEAN(CONCAT(CHAR(9), “Hello World”, CHAR(10), CHAR(33)))

Hello World!