REPLACE(x, FIND, REPL)

This function replaces all occurrences of a sub-string within a string, with a new sub-string. Note: This function performs a case-sensitive replacement.

Example:

Replace "Pranalitix " with "Pranalytix":

REPLACE("Pranalitix Tutorial", "Pranalitix", "Pranalytix")=“Pranalytix Tutorial”