Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

Use the SUBSTITUTE function to remove all spaces from a string

Input the formula: =SUBSTITUTE("a b c"," ","")