Completed

Excel Spreadsheet Work/Data Clean Up

I have a excel spreadsheet with 23 tabs. Each tab has multiple business addresses listed. However these addresses have some information that i want removed. I need someone to go through each tab and each line and remove the following information from the address cell so there just the business address left.

-the word 'headquarters'

-Phone/fax numbers

Then

Split each address over three columns A,B,C

A = Street Building Number/Name (eg 73b Elizabeth St )

B = City/Area, State, Postcode (eg Wetherill Park, New South Wales, 2164 )

C= Country (eg Australia)

Each tab has an ID number. This must remain in place.

Thanks

Skills: Data Entry, Data Processing, Excel, Visual Basic

See more: data cleaning in excel pdf, how to clean raw data in excel, macro to clean up data in excel, excel data cleaning tools, how to clean data in excel 2016, excel data cleaning tutorial, excel cleanup tool, clean up excel spreadsheet, excel spreadsheet vba data entry form, vba excel spreadsheet work, excel spreadsheet work bank statement, convert excel spreadsheet work web page, contract excel spreadsheet work, excel spreadsheet input data mask, excel spreadsheet import data google finance, excel spreadsheet custom data, excel spreadsheets work data, excel spreadsheet work completed, excel spreadsheet test data, excel spreadsheet work

About the Employer:
( 0 reviews ) Hamilton, New Zealand

Project ID: #19598923

Awarded to:

dalsaniyasonu123

Hello, I am ready to discuss project with you. Being experienced in working on several excel projects related to macro/formula/vba/functions/charts etc. Based on that i can quickly help you in getting your project don More

$80 NZD in 2 days
(37 Reviews)
4.8

28 freelancers are bidding on average $109 for this job

Motiurlaw

Okay understood. I have read through your project description and I think I am the right person you are looking for. I have done several similar jobs. You can check my profile here for details at [login to view URL] More

$90 NZD in 3 days
(245 Reviews)
7.0
rohitpithisaria

Hello I am an excel expert and have complete more than 100 projects in excel. I will send you a few samples of my past work for your kind perusal if required. I have read the job posting and understood the requiremen More

$140 NZD in 2 days
(116 Reviews)
6.6
MdAlamgirHoosain

Dear Sir I have check your attachment and clearly understood this task.I have good experience this type of job.I have done many job looking same.I am ready to start this task right [login to view URL] award [login to view URL] details ove More

$51 NZD in 1 day
(202 Reviews)
6.3
younus15

I checked your addresses on excel file. I can do your project according to your description 23 tabs with full delivery and without error. I would also complete your project with the highest precision and quality. I More

$150 NZD in 7 days
(103 Reviews)
5.9
MdJahangir1

Dear Sir, I am ready to start your jobs right now.I have done same project many times.I can complete this job in short time. My Best services are Data Entry, web scrap,research,email collect.I have a team (7members) More

$31 NZD in 1 day
(124 Reviews)
5.7
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

$100 NZD in 1 day
(95 Reviews)
5.5
milonhossain92

Hi I can do it and i have experience in this job. please give me chance,i will give you best quality. thanks.

$200 NZD in 3 days
(44 Reviews)
4.6
ScareCrow01

I am very good with excel and i can help you clean it up for you. Thank you

$166 NZD in 2 days
(20 Reviews)
4.3
MoenTek

Hi there, I have gone through project descriptions. We are a team working on day shifts and night shifts to offer overlap time. We have worked as Data Entry, Data Analyst and Customer Support with more than 4 More

$100 NZD in 1 day
(8 Reviews)
2.7
manditech

Hi, I have read your job details and got your requirements. I am ready to start working right now. What's the deadline for this job? Can we discuss for a while over chat now so that I am able to start working immed More

$88 NZD in 3 days
(15 Reviews)
2.2
dpdpdp

I am professional in Data Processing, PDF, Excel, Basic programing skills, especially I have working experience in the company before I apply for freelancer.com

$30 NZD in 1 day
(1 Review)
1.4
Rahulsomk

Our Services . • Lead Generation B2B • Data Procurement (CDQA) with Verified Contact number LinkedIn. • Valid Leads with Verified Contact number ( CDQA) • Data Entry Offline and Online. • Online Form Filling. • W More

$222 NZD in 5 days
(0 Reviews)
0.0
jessicathome

Hello! I'm interested in this job and I have the skills needed to deliver a high quality project for you. I've checked your spreadsheet and it seems pretty simple. So I could start today and finish it by tomorrow. Let More

$50 NZD in 2 days
(0 Reviews)
0.0
ruhulsam4u

To work for a dynamic and renowned organization that renders growing and learning opportunities through responsibilities and motivation.

$155 NZD in 3 days
(0 Reviews)
0.0
$155 NZD in 3 days
(0 Reviews)
0.0
abarissoft1

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do th More

$140 NZD in 7 days
(0 Reviews)
0.0
marshmallowpk

Hello! I am umar shehzad, I am a professional graphic designer I have 5 yr experience in this field. Writing Scan online and offline projects like express services of Database(Ms Access) Data Entry,Word,Excel,,Fill-abl More

$140 NZD in 5 days
(0 Reviews)
0.0
joieceb

Hi, I have been doing data entry for almost 8 years now and I think I can do this job for you. I am new at freelancer, but will assure you quality work for I was a quality analyst before and is keen to details. Thanks More

$111 NZD in 1 day
(0 Reviews)
0.0
zarwaa

I am extremely interested in your projecr.I am expert in excel and know avery aspect of [login to view URL] I have been working as a cheif accountant in a multinational company so my exposure to excel is very vast.I know al More

$36 NZD in 1 day
(1 Review)
0.0
kaiserhabib

Hello . Relevant Skills and Experience Give u best delivery ..thanks

$155 NZD in 2 days
(0 Reviews)
0.0