I know this is a little old but my cell phone service provider just added an extra digit to all cell numbers. What a pain to amend by hand. Bit of Google and I came across this post and thought I would give it a go.
So, I backed up my phone's contacts (the LG KP500 is a cheap but pretty clever "smart phone") onto the micro SD card (I don't have a USB cable), removed the micro SD card and put it into my PC, created a copy of the .vcf file with a later date time file name, opened the new file with Excel 2010 (accepting the default settings for a non-native file type) and had a bit of a play.
I did a find and replace on the line with the numbers in it (see below) and, very slowly intially, did a replace one-by-one. Eventually I found it was not coming up with any false positivies so I clicked "replace all". I also tidied up some of the contact names.
Replacing the micro SD card in the phone, I cleared all the numbers off the handset, did a restore from the new .vcf file on the micro SD card, did a check, and all is well. 200+ contacts updated in 10 minutes rather than hours.
For info, my excel commands were:
find:
replace:
(adding the new digit between the international dialing code and the first digit of the local number, so +6707123456 became +67077123456).
Please do a few tests first and check the results to ensure you have got teh find and replace right.
I was too scared to delete any unwanted contacts as I thought there might be some sort of algorhytm that tied them all together, but I don't think it would be a problem, espescially if you have kept the earlier .vcf file if something goes wrong!
Enjoy, this is a really easy fix.
Bookmarks