Excel Spreadsheet Macros
$10-30 USD
着払い
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, -122.42536252) would become column S value 37.7990950200297 and column T value -122.42536252
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 -122.42536252 would become -122.425362
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
プロジェクトID: #12635206
プロジェクトについて
アワード:
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 もっと
26人のフリーランサーが、平均$24 で、この仕事に入札しています。
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
Hi, I read the instructions and i can create the program based on the requirements. I would like to initiate chat.
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 もっと
I am an Expert in MS Office, can be a useful asset to your kind of project with faster resolution and Complete satisfaction.
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 もっと
cxcxxxxxxxxxxxxxxxxxxxxxxxxxxxcvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvcxcxxxxxxxxxxxxxxxxxxxxxxxxxxxcvvvvvvvvvvvvv もっと
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!!