Excel Replace Function. The Excel Replace function is similar to the Excel Substitute Function. The Substitute function replaces one or more instances of a given text string. Basic Description. The Excel Replace function replaces all or part of a text string with another string.