How to use Substitute Function in Excel

In Excel, the SUBSTITUTE function finds a string in a cell and replaces it with another string. The SUBSTITUTE function is case-sensitive and looks for instances of the string in the cell. You can choose whether the SUBSTITUTE function works on a specific instance of the string or if it affects all instances. This replaces, or substitutes, all occurrences of the old string with the new one. Even though Excel's official syntax uses the term text rather than string, you can use the function on both numbers and symbols. If you want to remove a character, you can simply substitute it with blank. It will replace one or more text strings with another text string. The function is useful when we wish to substitute old text in a string with a new string. The SUBSTITUTE function gives you the ability to conveniently replace characters in strings. You can also determine which incidence of the string you want to replace. The function also allows you to replace strings with blanks, or to replace blanks with strings. You can also use the Find and Replace Search feature in Excel to find and replace things. In this video, you will learn what is Substitute function & how to use Substitute Function in excel, how to replace the text using Substitute function with example.