CLEAN

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 will not be removed.
  • Google Sheets does not show non-printable characters in the UI, so using this function will not typically result in any visible changes.

See also

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

TRIM: Removes leading, trailing and repeated spaces in text.

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

Need more help?

Try these next steps:

Post to the Help Community Get answers from community members
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu