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.

You may end up with an Excel sheet with lots of cells with a leading apostrophe, which tells Excel to interpret the cell content as a text. It may not be very pleasant and makes all the other formulas ...

Use the SUBSTITUTE () function to remove non-printable characters in Excel Excel offers a CODE () function which returns the ASCII code for a given character.

You can use Excel's built-in substitute function to remove or replace a substring of a string of characters in Excel. This can include removing hyphens from Social Security numbers or any other ...