Removing parentheses and hyphen

QuestionEdit

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

AnswerEdit

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))