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

$10-30 USD

Завершено

Опублікований

over 6 years ago

$10-30 USD

Оплачується при отриманні

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

ID проекту: 15697270

Про проект

9 пропозицій(-ї)

Дистанційний проект

Активність 6 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

Доручений:

@MimiFL

$15 USD за 0 день

5,0

(398 відгуки(-ів))

6,8

9 фрілансерів(-и) готові виконати цю роботу у середньому за $20 USD

@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 за 1 день

0,0

(0 відгуки(-ів))

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 за 1 день

0,0

(0 відгуки(-ів))

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 за 3 дні(-в)

0,0

(0 відгуки(-ів))

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 за 1 день

5,0

(2 відгуки(-ів))

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 за 2 дні(-в)