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
-Remove leading, trailing and extra spaces
-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
-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)
-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.
-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.
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.
17 фрилансеров(-а) в среднем готовы выполнить эту работу за $22
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.
Dog. I would be excited to take on this project. With experience with VB and Excel, I am certain I would complete this project timely. Also, I can convert this to be used on Google Sheet.
I will give you a complete work as you [login to view URL] also convert the functions in google [login to view URL] me.I am a hard working poor man.I need money.
My self Shubham Sharma and I am Twenty Two years old.I have One Year Deploma In Multilingual Computer [login to view URL] hobbies is Reading Books, Playing Cricket,Cooking Food, Driving car or bikes.