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
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
Write to us: support@zohoforms.com