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 ...
While Excel was designed for numbers, it also involves text in cells. So, for example, if you want to transfer your data and limit the characters for each cell, you may want to know how to count ...