Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

Strips space, hyphen, colon, asterisk, underscore, left parenthesis, and right parenthesis

Input the formula: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1," ",""),"-",""),":",""),"*",""),"_",""),"(",""),")","")