Difference between revisions of "Documentation/How Tos/Calc: CLEAN function"

Revision as of 07:55, 17 July 2018

CLEAN

returns a text string with non-printable characters removed.

Syntax:

CLEAN(text)

returns text with all non-printable characters removed.

Spaces are not removed.

Example:

where cell A1 contains =CHAR(7) & "cat" & CHAR(8):

CLEAN(A1)

returns cat. The 2 non-printable characters are removed.

LEN(CLEAN(A1))

returns 3, the number of characters in cat.

• TRIM
• FIND
• PROPER
• REPLACE
• SEARCH
• SUBSTITUTE
• LEN

• Text functions

• Functions listed alphabetically
• Functions listed by category