Removing parentheses and hyphen

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

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

Advertisement

©2020 eLuminary LLC. All rights reserved.