Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

=SUBSTITUTE(a b c d, ,,,1)

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