Excel Spreadsheet Macros

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.

Thank you

Compétences : Saisie de Données, Traitement de Données, Excel

Voir plus : excel macros spreadsheet macro, macros work excel internet, macro dont work excel 2000, freelance work excel vba, track work excel, macros written excel 2000 work excel 2007, copy pdf spreadsheet excel, contract work excel access, googlemaps address excel longitude, copy spreadsheet excel, macros scripts excel, evaluation spreadsheet excel, excel 2000 macros work excel 2007, article submission work excel, macros working excel 2007, show project work excel, excel data type data process cnet 2008, work excel file, contract work excel, online contract work excel, copy browser spreadsheet excel code, macros project excel, putting existing spreadsheet excel, display macros select excel, data entry work excel

Concernant l'employeur :
( 257 commentaires ) United States

N° du projet : #12635206

Décerné à :


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

15 $ USD en 0 jours
(10 Commentaires)

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.

30 $ USD en 0 jours
(320 Commentaires)

Hi there, MS Excel expert here I completely understand your requirement, Will deliver required macros with 100% accuracy Feel free to award Thanks

24 $ USD en 1 jour
(46 Commentaires)

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

50 $ USD en 1 jour
(30 Commentaires)

I am an Expert in MS Office, can be a useful asset to your kind of project with faster resolution and Complete satisfaction.

25 $ USD en 1 jour
(22 Commentaires)

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

25 $ USD en 1 jour
(4 Commentaires)

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.

10 $ USD en 0 jours
(8 Commentaires)

Hi, I read the instructions and i can create the program based on the requirements. I would like to initiate chat.

25 $ USD en 0 jours
(15 Commentaires)

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

49 $ USD en 1 jour
(4 Commentaires)

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

30 $ USD en 1 jour
(2 Commentaires)

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

10 $ USD en 2 jours
(1 Commentaire)

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

25 $ USD en 1 jour
(1 Commentaire)
10 $ USD en 1 jour
(1 Commentaire)

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!!

15 $ USD en 0 jours
(0 Commentaires)

cxcxxxxxxxxxxxxxxxxxxxxxxxxxxxcvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvcxcxxxxxxxxxxxxxxxxxxxxxxxxxxxcvvvvvvvvvvvvv Plus

20 $ USD en 1 jour
(0 Commentaires)
10 $ USD en 0 jours
(0 Commentaires)

I want to work for this project

25 $ USD en 1 jour
(0 Commentaires)
20 $ USD en 2 jours
(0 Commentaires)
35 $ USD en 3 jours
(0 Commentaires)
25 $ USD en 1 jour
(0 Commentaires)

I did macro for my daily work and I would be able to do that for you too!

17 $ USD en 1 jour
(0 Commentaires)