Mega Code Archive
Categories
/
MSOfficeExcel 2007 Tutorial
/
Text Functions
=SUBSTITUTE(a b c d, ,,,1)
Input the formula: =SUBSTITUTE("a b c d", " ",",",1)