이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
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")결과: 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.