Here’s the thing, one must keep in mind that the SUBSTITUTE function is case sensitive, therefore, you must use it accordingly at all times. Furthermore, it is not possible to specify wildcard entries ...
Excel has native regex support, and it works exactly how you'd expect.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback