Suljettu

Excel list cleansing and fixing

I have a list in Excel. The list has maybe 8000 rows and is broken into a few different tabs. I need...

(4 non email tabs In Email tab: Make ALL CAPS names in email list into Upper/Lower case. For example--CHRIS into Chris or CHRIS WESTFALL into Chris Westfall (names only, emails don’t matter)

2 In all tabs: Groups to eliminate: Delete any row (the entire row) that has one of these names in it

Benefit Concepts

Ceridian Retirement Plan svcs

CoBiz

Cook Street Consulting

CREEKSIDE CONSULTING

Donohue Feinman

FirstTrust

Fringe Benefit Svcs

Gordon Hughes Banks

Holland Hart

Karsh Consulting

Lenderlive Network

Matrix Bancorp

Members Trust Co

Prizm Solutions

Reber Russell

Reptech

The Colorado Bank and Trust

The Cunningham Financial / Northwest MUTUAL)

The Pep Boys

Trustees for the George Clayton Trust

Woodmens Of The World

3 In all tabs: Mispelled: Fix the spelling or name to be correctly spelled

Aurora Denver Cardiologists

Dublin Primary Care contact is Debbie Milburn

Gart Sports is now -The Sports Authority

Rocky Mtn Law Enforcement

Stevinson 401k is actually Stevinson Automotive

Thruston in Aspen i Thurston Kitchens

TSN is in Fredrick / address is duped

United Rentals (they are out of Portland OR anyway)

4 In all tabs: Other fixes:

Davita is actually called GAMBRO (see it listed as well)

Gaima (its Gaiam) at 360 interlocken #300

Haynes Mechanical (should be Steve Moss)

Hydrologic Consultants Inc moved to 143 Union Blvd in Lakewood

ICG Communications (gone / kaput)

IHS Energy & I H S s/b IHS inc at 321 Inverness

Mayo Aviation ( GONE)

MCDONALD AUTOMOTIVE

Medical Group Mgt Assoc (it's Eric Cauble)

Merrick & Company (it's Allen Harvey - not Alan)

Miller Weingarten (it's Mike Smith + Suite 200)

Alton Way Suite 100 Centennial 80112

OEA is at 84501 E Quincy Ave Aurora Co 80016

Richfield Hospitality and Swan are the same Shannon Diernbach is VP of

HR

Sage Hospitality contact is Karsten Riggs

Salco contact is Robert Salvatore

Senior Resource Center (John Zabawa is President)

Space imaging is gone / now Geo eye of Virginia

The Farm Credit Council (contact s/b Bill Sparks or Linda Murphy

Tynan's Volkswagon (s/b Pete Tynan)

Verio (Lina George is new VP of HR)

White and Steele (600 17th St suite 600 N)

5 In Email tab: Delete all rows with bad emails. I will provide a separate folder of which emails are bad (basically these are emails that were returned because they were 'undeliverable'). There are about 800 bad emails to delete in the Excel list.

6 In all other tabs: Delete all #Disco companies/contacts (the entire row) from Master that are noted in Colorado - telemarketing lists.xls. (I will separately provide this and it includes only a small number of companies that want to be deleted from our lists)

I think this is probably just a few hours of work.

Thank you.

Taidot: Excel

Näytä lisää: excel list union, world financial group, work colorado, white case, united rentals, trust 300, think mutual bank, telemarketing law, telemarketing group, telemarketing consulting, telemarketing company names, tab bank, steve case, st bank, sports authority, small telemarketing companies, shannon medical center, shannon george, sage hospitality, sage consultants, russell medical center, robert miller, resource one solutions, prizm communications, pep boys

About the Employer:
( 0 reviews ) Englewood, United States

Projektin tunnus: #491841

30 freelanceria on tarjonnut keskimäärin 62 $ tähän työhön

teeares

This job appears simple. Should take about 8-10 hrs work.

30 $ USD 1 päivässä
(10 arvostelua)
3.3
edataworker1

Please check PMB for more details.

60 $ USD 2 päivässä
(3 arvostelua)
2.2
CADDesign911

Dear FAAssociates1, Please see PMB for details. Thank you. CADDesign911

45.34 $ USD 1 päivässä
(1 arvostelu)
1.0
shaildeogam

Hi, I am interested in this project. It will be finished within 4 hours. Regards!

50 $ USD 0 päivässä
(1 arvostelu)
1.0
octavcc

Hi there, Please see PM. Thank you, octav

75 $ USD 2 päivässä
(0 arvostelua)
0.0
adityamarwah

Hi. The work would require a max. of 2 hrs. of work including final testing. A separate user guide would be made available as well. and the template would not be limited to just the 8000 rows. u can add data as well. Lisää

30 $ USD 1 päivässä
(0 arvostelua)
0.0
premb20

Hi, I am prem, I am have team with hard workers. we are ready to work, please give me reply. I am waiting for your reply.

40 $ USD 30 päivässä
(0 arvostelua)
0.0
josephrowan

Hi. I can do this for you. I do this stuff all the time and could get started on it immediately. Thanks! J-

50 $ USD 1 päivässä
(0 arvostelua)
0.0
praveenkj

lets start now.

30 $ USD 3 päivässä
(0 arvostelua)
0.0
sheetalraut

I m working on advanced excel for last 7 yrs. Expert in excel VBA MACRO writing. Able to finish job in a single day.

60 $ USD 1 päivässä
(0 arvostelua)
0.0
pdyadav

sir, I am very very interest of your project. Ready to start your project

30 $ USD 2 päivässä
(0 arvostelua)
0.0
gravitydesktop

I'll try the best to accomplish the project. thanks

68 $ USD 6 päivässä
(0 arvostelua)
0.0
mojib500

hello i am ready

30 $ USD 3 päivässä
(0 arvostelua)
0.0
lory5

I can finished it by less than 4 hours. Just let me know when to start. Godbless!

30 $ USD 0 päivässä
(0 arvostelua)
0.0
charmaine00734

I am a new user, can i have the opportunity to help you?

100 $ USD 2 päivässä
(0 arvostelua)
0.0
PetkoTsenkov

Dear Sir/Madam i am ready to start your project. Please refer to your PMB. Thank You.

100 $ USD 1 päivässä
(1 arvostelu)
0.0
sbinfo

Hi Check PM for detail Thanks

150 $ USD 2 päivässä
(0 arvostelua)
0.0
akkinenisai

Hi, i'm a new freelancer and i'm good in excel i'm interested to work for you......

30 $ USD 2 päivässä
(0 arvostelua)
0.0
krishakmahan

i can complete in 1 hr just give me a chance

30 $ USD 1 päivässä
(0 arvostelua)
0.0
MAmalek

Dear sir, I would like to do this project. Believe me to be a reliable person for doing the job. I have a good internet connection. So please allow me to perform the project. Best regards, Abdul Malek

30 $ USD 1 päivässä
(0 arvostelua)
0.0