Excel Spreadsheet Macros

完了済み 投稿 7年前 着払い
完了済み 着払い

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

プロジェクトについて

26個の提案 リモートプロジェクト アクティブ 7年前

アワード:

Ashishpaliwall

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 もっと

$15 USD 0日以内
(13レビュー)
3.7

26人のフリーランサーが、平均$24 で、この仕事に入札しています。

cgullapalli

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 0日以内
(860件のレビュー)
8.0
emamulbd

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 もっと

$25 USD 1日以内
(69件のレビュー)
6.0
atifdar

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 1日以内
(83件のレビュー)
6.2
sarcscoin

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

$25 USD 0日以内
(66件のレビュー)
5.7
citijayamala

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 もっと

$50 USD 1日以内
(64件のレビュー)
5.6
KavTan

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 1日以内
(52件のレビュー)
5.7
telfordm

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 もっと

$30 USD 1日以内
(12件のレビュー)
4.3
cracken

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 もっと

$49 USD 1日以内
(6件のレビュー)
2.3
rafeemd

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 もっと

$25 USD 1日以内
(3件のレビュー)
2.4
stocktimemachine

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 もっと

$10 USD 2日以内
(レビュー1件)
1.5
alveenariaz93

A proposal has not yet been provided

$20 USD 2日以内
(0件のレビュー)
0.0
samanthula1

A proposal has not yet been provided

$25 USD 1日以内
(0件のレビュー)
0.0
mahi201

Kindly upload a sample sheet in advertisement, if possible

$30 USD 2日以内
(0件のレビュー)
0.0
valerie9489

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

$17 USD 1日以内
(0件のレビュー)
0.0
Swaroopa555

I want to work for this project

$25 USD 1日以内
(0件のレビュー)
0.0
momenulmomin75

cxcxxxxxxxxxxxxxxxxxxxxxxxxxxxcvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvcxcxxxxxxxxxxxxxxxxxxxxxxxxxxxcvvvvvvvvvvvvv もっと

$20 USD 1日以内
(0件のレビュー)
0.0
Rajeshnkrishn

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 0日以内
(0件のレビュー)
0.0