The UK has landlines in the format 01xxx xxxxxx and citys have 01xx xxx xxxx
Mobiles are always 07xxx xxxxxx
I have a corrupted csv from my iphone and the numbers are sometimes in the wrong format or the wrong column ie mobiles in home number and landlines in mobile number.
I have over 1000 contacts and I'm doing this manually.
There must be a better way???
TIA
Bookmarks