Explanation

The SUBSTITUTE function is full automatic.

All you gotta do is supply “old text” and “new text”.

SUBSTITUTE will replace every instance of the old text with the new text.

Excel formula: Clean and reformat telephone numbers

See this “clean telephone numbers” formula for an example.

If you should probably replace a character at a specific location, see theREPLACE function.

SUBSTITUTE is case-sensitive and does not support wildcards….

Excel SUBSTITUTE function