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

Launch Microsoft Excel. Enter data into the spreadsheet or use existing data. Select the cell you want to place the result Enter the formula Press Enter. Launch Microsoft Excel. Enter your data or use ...