Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

Search for the word Report and replaces those six characters it with the word Summary

=REPLACE(A1,SEARCH("Report",A1),6,"Summary")