D DBFIN Registered User. Local time Today, 05:11 Joined May 10, 2007 Messages 205 Aug 7, 2014 #1 Is there a way to convert a phone number in text format into a number and remove any dashs or parenthesis. What function can I use ? old format (951) 244-3011 new format 9512443011
Is there a way to convert a phone number in text format into a number and remove any dashs or parenthesis. What function can I use ? old format (951) 244-3011 new format 9512443011
pr2-eugin Super Moderator Local time Today, 10:11 Joined Nov 30, 2011 Messages 8,494 Aug 7, 2014 #2 Replace(Replace(Replace(Replace("(951) 244-3011", "-", ""), " ", ""), "(", ""), ")", ""). Or also could create your own UDF.
Replace(Replace(Replace(Replace("(951) 244-3011", "-", ""), " ", ""), "(", ""), ")", ""). Or also could create your own UDF.
V vbaInet AWF VIP Local time Today, 10:11 Joined Jan 22, 2010 Messages 26,374 Aug 7, 2014 #3 How about: Code: Replace(Replace(Mid("(951) 244-3011", 2), ") ", ""), "-", "")
