Clean/Edit 5 Excel Datasheets (conform phone #, city names)

so basically data provided to you in EXCEL DATA FIXING for the next, sometimes the easiest is to sort the excel spreadsheet by the column being worked on that way you can see all the records and those which have CLOSE but NOT EXACTLY ALIKE entries most important is not to make it perfect but to fix as much as possilbe 1) Telephone number some telephone numbers show up without + and country code sometimes no country code sometimes no + sign all the numbers should be dial able with + and country code number desired format = + (country code) + (number) so for example there are number 431 522 6636 so should be formatted like this (with +country code in front) +701 838 4445 for example all the US number should have +1 in front of them, most don't this should be done with an excel auto manipulation rather than by hand (by the way) save a lot of time (let's discuss if not clear) best to sort the table by country to help on this one 2) city name , region names sometimes are not consistent for city, country please make sure that for example there is a BRUXELLES and BRUSSELS which is the same choose one and make all the same 3) ZIP CODE same for zip codes sometimes F-75007 but correct is probably 75007 only is sufficient 4) Special Characters special characters like é è ñ do not display properly in our system lookout for garbled characters if you see them simplify them down (take away accents) DATA ADDING 5) wherever there is no latitude/longitude information, columns B and C please add longitude and latitude information for the address provided there are a number of resources to do that [login to view URL] [login to view URL]