Author: Oscar Cronquist Article last updated on March 29, 2018

The CLEAN function deletes nonprintable characters in a value, more specifically, it is designed to delete the first 32 nonprinting characters in 7-bit ASCII code.

The Unicode character set has additional nonprinting characters (values 127, 129, 141, 143, 144 and 157), however, the CLEAN function does not delete these characters.

Formula in cell D3:

=CLEAN(B3)

The picture above shows ANSI codes for each character so you easily can spot the characters that the CLEAN function can delete.

For example, ANSI character 29 is deleted by the CLEAN function above, 29 is among the first 32 nonprinting characters in 7-bit ASCII code.

Excel Function Syntax

CLEAN(text)

Arguments

text Required. A value from which you want to remove nonprintable characters