CLEAN

αƒαƒ αƒαƒ‘αƒαƒ‘αƒ”αƒ­αƒ“αƒ˜ αƒ‘αƒ˜αƒ›αƒ‘αƒαƒšαƒαƒ”αƒ‘αƒ˜ αƒ‘αƒ’αƒ αƒ˜αƒ₯αƒαƒœαƒ˜αƒ“αƒαƒœ αƒαƒ›αƒαƒ˜αƒ¦αƒ”αƒ‘αƒ.

αƒ‘αƒ˜αƒœαƒ’αƒαƒ₯αƒ‘αƒ˜

CLEAN(გეαƒ₯αƒ‘αƒ’αƒ˜)

Text refers to the text from which to remove all non-printable characters.

αƒ›αƒαƒ’αƒαƒšαƒ˜αƒ—αƒ˜

=LEN(CLEAN(CHAR(7) & "LibreOffice Calc" & CHAR(8))) returns 16, showing that the CLEAN function removes the non-printable Unicode U+0007 ("BEL") and U+0008 ("BS") characters at the beginning and end of the string argument. CLEAN does not remove spaces.

αƒ“αƒαƒ™αƒαƒ•αƒ¨αƒ˜αƒ αƒ”αƒ‘αƒ£αƒšαƒ˜ αƒ—αƒ”αƒ›αƒ”αƒ‘αƒ˜

tip

CLEAN wiki page.


Text Functions

Please support us!