Excel: Clean Function

In Excel, the Clean function removes all nonprintable characters from a string.

The syntax for the Clean function is:

Clean( text )

text is the value that has all nonprintable characters removed from.

Applies To:

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Clean(A1) would return "hi there"

=Clean(A2) would return '"this is a test"