Replace occurrences of a specific text

Ask the Community Formulas
#1

How can I replace occurrences of a specific text with new text in Stackby using the SUBSTITUTE() function?

#2

Use SUBSTITUTE() like this:
SUBSTITUTE({Example Text},“apples”, “Oranges”)