Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

=SUBSTITUTE(two two ,two, three,2)

Input the formula: =SUBSTITUTE("two two .","two", "three",2)