Most Excel users know Ctrl+F as a quick way to find specific text or values in a spreadsheet. You might also know Ctrl+H, but probably think of it as little more than a way to replace one value with ...

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 ...