The CLEAN function takes a supplied text string and removes all non-printable characters.
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.
|text||The text from which to remove non-printable characters.|
Note: The text argument can be supplied to the function either directly, as a text string returned from another formula, or a reference to a cell containing text.
|1||Text to Clean||Formula||Result||Notes|
|2||⊥⊥clean text||=CLEAN(A2)||clean text||Has non-printable characters at the start|
|3||clean text⊥⊥||=CLEAN(A3)||clean text||Has non-printable characters at end|
|4||clean⊥⊥text||=CLEAN(A4)||clean text||Has extra non-printable characters in the middle|
|5||⊥clean⊥⊥text⊥||=CLEAN(A5)||clean text||Has non-printable characters at start, in middle, and at end|