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

If you've ever used Excel, you're probably familiar with the panicky feeling that comes with using Microsoft's spreadsheet app. It can feel a little overwhelming and tough to navigate, even if you are ...