Hey everyone - I wanted to give you a heads up that we just added a new formula, SubstituteAll, that you can use to find and replace all instances of the search string.
SubstituteAll("banana", "a", "o") = "bonono"
We looked into changing the default behavior of Substitute, but making backwards-incompatible changes to the formula language is quite difficult. Hopefully this will make it easier going forward!