1. Spreadsheet.com Support
  2. Functions
  3. Text functions

CLEAN

Removes all non-printable characters from the string.

Sample Usage

CLEAN(C5)

Syntax

CLEAN(text)

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

 

Examples

CLEAN(C5) removes the non-printable characters from the text string in cell C5.

Notes

  • This function only removes non-printable ASCII characters. Non-printable Unicode characters that aren’t found in ASCII are not removed.