2204, 2019 The SUBSTITUTE Function Kornilios Ampatzis/ April 22, 2019/ Functions It searches for a specific text in string and replaces it with another. It is a case-sensitive function.