CLEAN
āĻ¸ā§āĻā§āĻ°āĻŋāĻ āĻšāĻ¤ā§ āĻ¸āĻāĻ˛ āĻ āĻŽā§āĻĻā§āĻ°āĻŖā§ā§ āĻ āĻā§āĻˇāĻ° āĻ āĻĒāĻ¸āĻžāĻ°āĻŖ āĻāĻ°āĻž āĻšāĻ¯āĻŧāĨ¤
CLEAN("Text")
āĻĒāĻžāĻ ā§āĻ¯ āĻĒāĻžāĻ ā§āĻ¯ āĻ¨āĻŋāĻ°ā§āĻĻā§āĻļ āĻāĻ°ā§ āĻĨāĻžāĻā§ āĻ¯āĻž āĻĨā§āĻā§ āĻ¸āĻāĻ˛ āĻ āĻŽā§āĻĻā§āĻ°āĻŖāĻ¯ā§āĻā§āĻ¯ āĻ āĻā§āĻˇāĻ° āĻ āĻĒāĻ¸āĻžāĻ°āĻŖ āĻāĻ°āĻž āĻšā§āĨ¤
=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.
