Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

CLEAN removes all nonprintable characters from text

Input the formula: =CHAR(7)&"text"&CHAR(7)