Make Substitute replace all matches

I know there is RegexReplace formula. But why Substitute replaces only first match? I think there are more use cases with the need to replace all occurences, not only first.

3 Likes

just came across this issue where i want to turn a string in a url parameter. needed to replace all spaces with dashes and lowercase. but found that substitute only replaces the 1st space, and not all matches