Removing parentheses and hyphen

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


©2021 eLuminary LLC. All rights reserved.