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


Cook Street Consulting


Donohue Feinman


Fringe Benefit Svcs

Gordon Hughes Banks

Holland Hart

Karsh Consulting

Lenderlive Network

Matrix Bancorp

Members Trust Co

Prizm Solutions

Reber Russell


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)


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


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, excel list rows credit union, world financial group, work in colorado, white & case, white and case, united rentals, union bank, trust 300, t.i. automotive, think mutual bank, the world bank, telemarketing law, telemarketing group, telemarketing for it companies, telemarketing consulting, telemarketing company names, tab bank, steve case, st bank, s&t bank, s & t bank, sports authority, small telemarketing companies, shannon medical center

Tietoa työnantajasta:
( 0 arvostelua ) Englewood, United States

Projektin tunnus: #491841

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


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

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

Please check PMB for more details.

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

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

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

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

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

Hi there, Please see PM. Thank you, octav

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

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)

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)

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)

lets start now.

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

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)

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

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

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

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

hello i am ready

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

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)

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

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

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)

Hi Check PM for detail Thanks

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

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)

i can complete in 1 hr just give me a chance

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

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)