CLEAN removes all nonprintable characters from text : CLEAN « Text functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Text functions
  3. CLEAN
Input the formula: =CHAR(7)&"text"&CHAR(7)
Input the formula: =CHAR
22.4.CLEAN
22.4.1.CLEAN removes all nonprintable characters from textCLEAN removes all nonprintable characters from text
22.4.2.=CLEAN(CHAR(7)&"text"&CHAR(7))=CLEAN(CHAR(7)&