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.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"cinnamngrl" <(E-Mail Removed)> wrote in message
news:2c90bd1d-6705-49c7-a9bb-(E-Mail Removed)...
>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?