CLEAN

The CLEAN function removes all non-printable characters from text.

Syntax

=CLEAN(text)

Parameters

• text: The text to clean

Examples

=CLEAN("Hello World" & CHAR(7)) // Returns "Hello World"
=CLEAN("First Line" & CHAR(10) & "Second Line") // Returns "First LineSecond Line"