Definition

Returns the text with the non-printable ASCII characters removed.

Sample Usage

CLEAN("AF"&CHAR(31))

Syntax

CLEAN(text)

  • text - The text whose non-printable characters are to be removed.

Notes

  • This function only removes non-printable ASCII characters. Non-printable Unicode characters that aren’t found in ASCII are not removed.
  • Google Sheets does not show non-printable characters in the UI, so using this function will typically not result in any visible changes.

See Also

CHAR: Convert a number into a character according to the current Unicode table.

TRIM: Removes leading and trailing spaces in a specified string.

SUBSTITUTE: Replaces existing text with new text in a string.

In order to use the CLEAN formula, start with your edited Excellentable:

 

Then type in the CLEAN formula in the area you would like to display the outcome:

 

By adding the values you would like to calculate the CLEAN formula for, Excellentable will generate the outcome:

 

Error.

User does not have sufficient privileges to access this Content
Learn More