Standardized telephone format

[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?

 

[Ken Slovak]

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.