Excels macro to clean company name and extract info

Cancelled Posted 4 years ago Paid on delivery
Cancelled Paid on delivery

Implement excel functions to clean a company name and extract information from a company name. Functions are simple. The logic will use lists of keywords we provide

Conversion includes

General format

-Collapse initials

-Remove punctuation

-Remove leading, trailing and extra spaces

Suffixes

-Remove unless without suffix, company is only 1 word. We will provide a list of suffixes that is expected to be added to. (example: inc, llc, corp, group, systems). Final list will be hundreds long to plan code efficiency for it

NoteWords

-Remove NoteWords: NotesWords are text that appears after key words. Example: Skype (acquired by Microsoft). “acquired by” is a key word. “Acquired by Microsoft” would be removed. The list of key words list will be hundreds long to plan code efficiency for it. (formerly, acquired by, division of, etc)

Locations

-We have a list of locations, that should be removed from the company name. Location should be removed if in parenthesis or following a delimiter (example: Fun Systems - Los Angeles would be “Fun Systems”. The list of location will be thousands long so plan code efficiency for it.

Acronym

-Compare words in company name and remove acronym. There will be a list of “skip” words that are not considered part of Acronym (of, the, a, for, etc). Example: "National Association of Developers (NAD)" would become "National Association of Developers"

The Main Function will be called CompanyCommon()

In addition, we need functions that can extract the above information using the same code base.

GetNoteWord()

GetLocation()

GetAcronym()

See screenshot for before/after examples. We will provide lists of Suffixes, NoteWords, and Locations to the winning bidder.

To show us that you have GREAT attention to detail and that you read this posting. Put the name of your favorite animal as the first word in your bid

When this is done, we want to convert the functions to also use in Google sheets, let us know if you can also do that.

Good luck

Excel Visual Basic Visual Basic for Apps

Project ID: #23940437

About the project

14 proposals Remote project Active 4 years ago

Awarded to:

viveksr

TIGER. Hi, I have read through the details and I am interested in this project.I have already done many data conversation and data clean up projects. I assure you that I will be able to deliver you the code which meet More

$30 USD in 3 days
(6 Reviews)
3.3

14 freelancers are bidding on average $24 for this job

maurineted5

I have read the instructions and the question. I am well conversant with the field and I believe I can offer a high quality paper on this assignment delivered on time.

$55 USD in 1 day
(11 Reviews)
3.8
VbaStudio

Dog. I'm an expert in Excel and VBA macros. I can do everything you need. I had done similar things before.

$30 USD in 5 days
(14 Reviews)
3.8
Maher4215

I can work on your terms I have 15 years experience in data entry and my typing speed is 75 WPM i have good knowledge in ms word and ms excel, i can work manually and submit the work on time with accuracy kindly contac More

$20 USD in 1 day
(0 Reviews)
0.0
noobydrx

.......... . .. .. . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . .. .. . . . . . .. . ...................

$20 USD in 2 days
(0 Reviews)
0.0
ibrahimbahloul07

ok i can do it

$10 USD in 2 days
(0 Reviews)
0.0
akanshaj1706

Dear Sir, I completely understand your work & I’m sure that I am fully capable of doing this. I have required skills for your project . please give me the opportunity to do your project.. i shall assure you that I wil More

$20 USD in 2 days
(0 Reviews)
0.0
sanjusalooni7

I am Very honest person.

$25 USD in 1 day
(0 Reviews)
0.0
Varshapotan02

I'm Excell expert please give me a chance to work with you ... just discuss with me about your job ...

$10 USD in 5 days
(0 Reviews)
0.0