The SUBSTITUTE function in Excel is used to replace a particular text with another text. Here, we will show you how to use the SUBSTITUTE function to remove dashes in Excel.

Sometimes, after adding text to a cell in Excel, you may want to count the total number of specific characters for that specific cell. In this case, you can use LEN with the SUBSTITUTE function.