In this tutorial, we will explain how to use the Substitute as well as the Replace function in Excel. The formula for the Substitute function is: Substitute (text,old_text,new_text,[instance_ num]) ...

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.

Excel functions: 7 ways to use Text functions to manage data How to replace words; extract first and last words, matched or a specific words in a string of text ...

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