Replace

The Replace function manipulates text strings by allowing users to replace specific characters or substrings. The Replace function operates in a case-sensitive manner. With its intuitive syntax and dynamic input options, the Replace function empowers users to enhance productivity and streamline data processing workflows effectively.

Syntax

Replace(Source text string, Old text string, New text string)

Example

Replace("I like bananas", "bananas", "apple") -> returns "I like apples"