Removes all non-printable characters from a text string.
Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.
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")Kết quả: 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.