Excel Replace Text with New Text or Blank
Excel Replace Text with New Text or Blank using Substitute function. We will clean up Phone number with special characters and spaces. You can replace any text in a cell with a new text, the substitute function also allows you to specify the number of instance to replace text for. You can also use this to replace a given text with blanks or fix typos in the text.
We will also learn how to use Substitute function multiple times in same call.
#ExcelReplaceText #ExcelReplaceTextWithBlanks