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






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)&