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.

Install the Remove Duplicates add-on from the Google Workspace Marketplace. In your sheet, click Extensions, then Remove Duplicates, and choose: Find Duplicates or Uniques.

You can remove duplicates in Excel in a few steps. Duplicates can create problems when you're dealing with data.

If there are many blank rows in your Excel sheet, you can delete them and tidy up the document using the "Find and Select" feature. Here's how.

In Excel, when you need to debug a complex web of formulas, you need to trace dependent and precedent formulas. Here's how they work.