The Excel CLEAN function removes all non-printable characters from a supplied text string.
The function is designed to remove the non-printable characters, represented by numbers 0 to 31 of the 7-bit ASCII code, which are often found at the start of data that has been imported into Excel from other applications.
The syntax of the Clean function is:
where the text argument is the text string that you want to remove the non-printable characters from.
The following spreadsheet shows the Excel Clean function applied to four different text strings.
All four of the above examples give the same result, which is the string,
For further information and examples of the Excel Clean function, see the Microsoft Office website.