Removes all non-printable characters from a text string.
Syntaxis
CLEAN(text)Argumenten
textvereist
The text or reference to a cell containing the information you want to clean.
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")→HelloRemoves the bell character (ASCII 7) from the beginning of the string.
Select the cell
Click on the cell where you want the cleaned text to appear.
Enter the formula
Type =CLEAN(A1) assuming A1 contains the text with non-printable characters.
Press Enter
Press Enter to execute the function and display the cleaned result.
No, CLEAN only removes non-printable characters. Use the TRIM function to remove extra spaces.