Removes all non-printable characters from a text string.
Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.
CLEAN(text)The CLEAN function is designed to remove the first 32 non-printable characters in the 7-bit ASCII code (values 0 through 31) from text. It is commonly used to clean data imported from other applications that may contain control characters or line breaks that cause formatting issues.
=CLEAN(CHAR(7) & "Hello")Ergebnis: Hello
Removes the bell character (ASCII 7) from the beginning of the string.
No, CLEAN only removes non-printable characters. Use the TRIM function to remove extra spaces.