Please
look at column B , i have retyped them then look at C i have added a zero prior the phone
I want macro to do me the needful have 5ooo contacts that i dont wona spend time typing
Any number that is greater than 10 digits and does not have country code 255 comment ignore
Finally delete all rows that have the word IGNORE
See file attached
Thank you
Bookmarks