My source workbook has a customer list with phone numbers.
I am writing a VBA program in another workbook to look up these phone numbers. My problem is that the phone numbers were keyed in by different people in different formats (234) 567-7890 and 234-567-7890 and even 234 567-7890.
I need to convert these to just a 10 digit string 2345677890 regardless of the original format. I found some code that with read each character and determine if it is a number, but I wanted to know if there was something less complicated.
Thank you.
Bookmarks