The REPLACE function searches a given string for a substring and replaces it with replacement string.