Discover how to use the REPLACE function to substitute occurrences of a substring within a string.