Looking for a way to tidy up your spreadsheet and reduce its size without having to use dynamic range formulas like OFFSET, ...

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. This method also works ...