Explanation

The SUBSTITUTE function lets you replace text by matching content.

In this case, we want to remove hyphens from telephone numbers.

SUBSTITUTE will replace all instances of “-” with nothing.

Excel formula: Remove text by position

Note that SUBSTITUTE is a case-sensitive function.

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

Excel formula: Remove leading and trailing spaces from text

Excel SUBSTITUTE function