Standardized telephone format

  • Thread starter Thread starter cinnamngrl
  • Start date Start date
C

cinnamngrl

I am having a lot of trouble removing doubles from my outlook. it is
because identical numbers are formatted differently. My first attempt
to clean it up made things worse. what am i missing? is there a
function that just compares digits, ignoring other characters?
 
No, there's no function like that, you'd have to write one. It wouldn't be
difficult at all, just get the ASC() value of the string character at a
position and compare it to the ASC() values of 0 and 9. If it's between
those it's a number. Anything outside that range (48 to 57) is something
else.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting issue with imported telephone number! 2
Format a Telephone number 2
format cell with multiple formats for telephone numbers 1
Programing Telephone Numbers 2
Comparing telephone numbers 3
computer as a telephone 4
revise telephone format in Outlook contacts 1
telephone number formating/formats 1

Back
Top