Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

=CLEAN(CHAR(7)&text&CHAR(7))

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