Welcome to Portal
Removes the non-printable characters from a given text string.
Syntax
Remarks
The CLEAN function removes the first 32 non-printable characters in the 7-bit ASCII code from the given input.
Examples
Input |
Result |
="Zoho"&CHAR(7)&"Sheet" |
ZohoSheet |
Line
|
LineBreak |
Possible Errors
Errors |
Meaning |
#N/A! |
|
#NAME! |
|
#VALUE! |
|
#REF! |
|
Similar Functions
Subscribe to receive notifications from this article.