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

Latest revision as of 15:24, 2 February 2024

FUNCTIONS

returns a text string with non-printable characters removed.

CLEAN(text)

returns text with all non-printable characters removed.

Spaces are not removed.

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.

See Also

@@ Line 1: / Line 1: @@
-__NOTOC__
+{{DISPLAYTITLE:CLEAN function}}
+{{Documentation/CalcFunc TextTOC
+|ShowPrevNext=block
+|PrevPage=Documentation/How_Tos/Calc:_CHAR_function
+|NextPage=Documentation/How_Tos/Calc:_CODE_function
+}}__NOTOC__
 == CLEAN ==
@@ Line 19: / Line 24: @@
 : returns <tt>'''3'''</tt>, the number of characters in <tt>'''cat'''</tt>.
-{{Documentation/SeeAlso|
+{{SeeAlso|EN|
 * [[Documentation/How_Tos/Calc: TRIM function|TRIM]]
 * [[Documentation/How_Tos/Calc: FIND function|FIND]]