Make Substitute replace all matches

#1

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.

2 Likes