Text Functions MSOfficeExcel 2007 Tutorial

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