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.
Greetings of the day! I would love to assist you with the project. I have been working in excel for last 3 years now. I can assure you the best quality work. I will do the job in max 2 hours. Would love to hear back Plus
27 freelance font une offre moyenne de $23 pour ce travail
Hi, I am good at Excel and vba. I have understood the requirements and I am ready to make it. Looking forward to discuss in the chat.
Hi there, MS Excel expert here I completely understand your requirement, Will deliver required macros with 100% accuracy Feel free to award Thanks
Expert in Excel, Excel formulas, and all excel functions, macros, lookup concepts. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Can complete on time with Plus
I am an Expert in MS Office, can be a useful asset to your kind of project with faster resolution and Complete satisfaction.
Dear Client, Your job posting catches my attention and I submit the proposal as a desired candidate. I'm a full time freelancer experienced in Lead Generation, Virtual Assistant, PDF conversation, Social Media Marke Plus
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.
Hi, I read the instructions and i can create the program based on the requirements. I would like to initiate chat.
Hi, I am well equip to this kind of task, can handle it pretty well. In fact, I already done related to this job before. Let me know the best of your time so we can discuss further based on your requirements and we ca Plus
Hi, I am a native English speaking finance professional with over 15 years experience using Excel. I can help you with your macro. To clarify - would you like all 3 steps completed in the one macro? Or would you like s Plus
Hello I am a programmer. It is available both Visual Basic and delphi. I have some work, in an Excel spreadsheet. We aim to serve you with quality and commitment to accuracy. i will use formulas of excel and i will don Plus
I have sound experience (5+ years) in Excel/Data Entry and Visual Basic for Applications development and ability to learn new task quickly. I am efficient and Trustworthy. I can complete this task within a couple o Plus
I have experience in data entry jobs much similar to this kind of jobs! I can complete the given file on the same day with good quality!!