CLEAN function

CALC FUNCTIONS

Text Functions

< Previous Section

Next Section >

FUNCTIONS

• ARABIC
• ASC
• BASE
• BAHTTEXT
• CHAR
• CLEAN
• CODE
• CONCATENATE
• DECIMAL
• DOLLAR
• EXACT
• FIND
• FIXED
• JIS
• LEFT
• LEN
• LOWER
• MID
• PROPER
• REPLACE
• REPT
• RIGHT
• ROMAN
• SEARCH
• SUBSTITUTE
• T
• TEXT
• TRIM
• UNICHAR
• UNICODE
• UPPER
• VALUE

< Previous Page

Next Page >

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.

---

See Also

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

• Text functions

• Functions listed alphabetically
• Functions listed by category