Strips space, hyphen, colon, asterisk, underscore, left parenthesis, and right parenthesis : SUBSTITUTE « Text functions « Microsoft Office Excel 2007 Tutorial

Strips space, hyphen, colon, asterisk, underscore, left parenthesis, and right parenthesis : SUBSTITUTE « Text functions « Microsoft Office Excel 2007 Tutorial

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