This should be an easy task for someone with the requisite spreadsheet skills. The deliverable is for macros that will do the following using the attached spreadsheet as an example:
1) column G (Address). Replace double spaces with single space. For example '1575 Filbert St' will become '1575 Filbert St'
2) Column R location value broken up into 2 additional columns: Location Latitude column S and Location Longitude column T. Process would be to take column R value, and remove the parentheses () and then populate column S with the value preceding the comma and then column T with the value AFTER the comma. For example: column R value (37.7990950200297, [url removed, login to view]) would become column S value 37.7990950200297 and column T value [url removed, login to view]
3) Lastly, format the values in column S and T to 6 digits of decimal precision. For example above, column S value 37.7990950200297 would become 37.799095 and column T value [url removed, login to view] would become [url removed, login to view]
The deliverable is to return the original spreadsheet with macros that can be run to generate a modified spreadsheet in the above format.
I guarantee immediate selection, speedy payment, 5 star rating and recommendation for successful delivery.
27 freelance font une offre moyenne de $23 pour ce travail
Hi , I am interested by your offer I will be happy to do this job even though I'm new in the field of freelance. Let me know more details of this work. I will start working immediately :) Br.