Excel Extract Text Formula... not so simple - 21/11/2017 14:24 EST

$10-30 USD

Complété

Publié

il y a plus de 6 ans

$10-30 USD

Payé lors de la livraison

Need a text extract formula for excel. The formula needs to locate one of the following phrases (the first time it occurs) in a cell: LLC Limited Liability Company Limited Ltd Ltd. Company Corporation Incorporation Corp. Inc. Corp Inc Co. Co Partnership Limited Partnership PC Professional Company and then return that phrase along with all of the text before it until it reaches a ";" If there is no ";" it returns everything before the phrase Example 1, a cell may contain the following: J Chris Kantarian MD; James A Wolf MD; Jessica C Morales DO; Jozef A Ottowicz MD; Steven R Casos MD; St Luke's Clinic - Treasure Valley LLC; St Luke's Regional Medical Center Ltd.; ABC Corp.; XYZ Inc.; YYZ Limited Hence, the formula would only extract: St Luke's Clinic - Treasure Valley LLC (with no leading spaces) Example 2, a cell may contain the following: XYZ LLC; Jim Smith; Alice Smith Hence, the formula would only extract: XYZ LLC Example 3, a cell may contain only: XYZ LLC (where there is no “;” in the text) Hence, the formula would return: XYZ LLC

Excel

N° de projet : 15697270

Concernant le projet

9 propositions

Projet à distance

Actif à il y a 7 ans

Cherchez-vous à gagner de l'argent ?

Adresse e-mail

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais

Soyez payé pour votre travail

Surlignez votre proposition

Il est gratuit de s'inscrire et de faire des offres sur des travaux

Décerné à :

@MimiFL

$15 USD en 0 jour

5,0

(398 commentaires)

6,8

9 freelances proposent en moyenne $20 USD pour ce travail

@mriqbalhabib

Dear Sir, I read your job description. I would like to apply as your project.I have 5 years experience. If you like to hire me. I am ready to do your project. Thanks Relevant Skills and Experience yes Proposed Milestones $25 USD - no

$25 USD en 1 jour

0,0

(0 commentaires)

0,0

@fmemran

I am a Data Entry professional; I have experience and expertise on M/s Office Applications. I have passed a long time with several local concern. So, I think you will get the best work from me. Relevant Skills and Experience Excel Proposed Milestones $25 USD - Excel

$25 USD en 1 jour

0,0

(0 commentaires)

0,0

@mohdlatief

Hello, My name is latief a certified lead generation expert,got 6+ years of experience in lead generation. I have designed a tool that makes use of API technologies and i use that to generate leads. I am fully expert in web research, extracting email, data mining, Google, Bing, Yahoo, MS Office,Excel, (Full), CSS Data entry ,web scraping , B2B Marketing, Lead Generation, Directory and other related programs. You can test the quality of my leads and also i provide leads at best price in the market I can provide samples ,if needed Regards Latief

$10 USD en 3 jours

0,0

(0 commentaires)

0,0

@vismayilov

Good day Dear Employer, I can do this work very quickly and with the highest quality. I will even provide the functions and macros which will be used for this work. Relevant Skills and Experience Excel Macros VBA and etc... Proposed Milestones $25 USD - Project completion

$25 USD en 1 jour

5,0

(2 commentaires)

0,0

@Mustakin0168

Hi sir, I read though your project description. I am interested in your project. I am a Data entry expert. I have experienced in your project sir. I want to complete 100% properly. Thank you Sir

$15 USD en 2 jours