May 25, 2008
i'm a complete excel novice, but i think this should be pretty easy for you guys...
View 9 Replies
i just bought a new satnav system after 4 years with tomtom...
anyway, to get the speed camera database to work with it, i must add a couple of commas at the end of each set of co-ordinates contained within the spreadsheet, like this:
thing is, most of them don't have the 2 commas at the end and just end with the number, like this:
therefore, what i need to do is make up a formula in excel to search for a double comma at the end of each set of co-ordinates and if it doesn't already have them, then it should insert them...
i'm guessing for anyone with excel experience, this should be pretty easy to solve...