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

$10-30 USD

Dokončeno

Zveřejněno

před více než 6 roky

$10-30 USD

Zaplaceno při doručení

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

IČ projektu: 15697270

O projektu

9 nabídky

Vzdálený projekt

Aktivní před 6 roky

Chcete si vydělat nějaké peníze?

E-mailová adresa

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec

Získejte za svou práci zaplaceno

Načrtněte svůj návrh

Registrace a podávání nabídek je zdarma

Uděleno:

@MimiFL

$15 USD v 0 dni

5,0

(398 recenze)

6,8

9 freelanceři nabízejí v průměru $20 USD za tuto práci

@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 v 1 dni

0,0

(0 recenze)

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 v 1 dni

0,0

(0 recenze)

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 v 3 dnech

0,0

(0 recenze)

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 v 1 dni

5,0

(2 recenze)

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 v 2 dnech