Related Function:

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.

Syntax

=CLEAN(text)

Arguments

Argument Description
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.

Examples

  A B C D
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