Last Edited By **Krjb Donovan** **Last Updated:** Mar 05, 2014 09:53 PM GMT

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

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

Advertisement

©2024 eLuminary LLC. All rights reserved.