Removing parentheses and hyphen

Question

QUESTION: I want to display (111)111-1111 as 1111111111 Is there any formula to display numbers without parentheses and hyphens.I want to display telephone numbers as numbers

Answer

Type in the formula given below in cell B1. Please note that the original number is in cell A1 (the example you have given). =MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)&MID(A1,FIND(")",A1)+1,FIND("-",A1)-FIND(")",A1)-1)&RIGHT(A1,LEN(A1)-FIND("-",A1))