CLEAN « Text functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Text functions
  3. CLEAN
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)&