Write some excel code to remove strings

Kapalı İlan edilme: 7 yıl önce Teslim sırasında ödenir
Kapalı Teslim sırasında ödenir

I have the following data in column K in bookings sheet.

Dj Ian Duggan

Dj Ian O Sullivan

Briar Rose

Jason Nolan Apple Computers

Ingrid Homich Cork International Hotel

Mary Foley Mobile

Natasha Meteor

Emer Igbokwe PR Agency

Carol Crowley Bc Cobh

Paul O Leary Bc Crosshaven

Donal Mc Grath Bc Dungourney

James Mc Shane

Im looking for code to remove the yellow highlighted txt above.

Here are some of the rules

If first word = ‘dj’ remove this word

If 2nd word is not (“0” or “mc”)

{

Remove all words after second word

}

Else

{

Remove all words after 3rd word

}

Looking for somebody to write some code for this

Please see attached document.

My Budget is 30$ and I need it done in an hour or two

Veri Girişi Veri İşleme Excel

Proje NO: #10522298

Proje hakkında

39 teklif Uzak proje Aktif 7 yıl önce

Bu iş için 39 freelancer ortalamada €1734 teklif veriyor

jaylancer43

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(783 Değerlendirme)
8.6
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your pr Daha Fazla

€250 EUR in 2 gün içinde
(254 Değerlendirme)
7.6
zebracaro

I can do it for you quickly and exactly .

€250 EUR in 3 gün içinde
(117 Değerlendirme)
7.1
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega Daha Fazla

€250 EUR in 3 gün içinde
(279 Değerlendirme)
7.1
The24CarrotsInc

Will do it for 20EURO Will do it for 20EURO Will do it for 20EURO Will do it for 20EURO Will do it for 20EURO Will do it for 20EURO Will do it for 20EURO

€250 EUR in 10 gün içinde
(56 Değerlendirme)
5.7
bhupendrayadav

I am postgraduate (MBA) in finance having more than five years of experience. I have expertise in VBA and Excel. Currently working in an MNC Analytical company in a large financial model having dashboards and presentat Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(42 Değerlendirme)
5.7
archanaoswal

I have excellent command on MS Excel. I can do the task within a couple of hours for $25 I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Build a r Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(82 Değerlendirme)
5.8
sergpooh

I'll do it for $30 .

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(42 Değerlendirme)
5.5
tasleem83

I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start

€526 EUR in 10 gün içinde
(115 Değerlendirme)
5.5
prabakarm23

I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I Daha Fazla

€555 EUR in 10 gün içinde
(50 Değerlendirme)
4.7
serdaryalcin

Hi, Would you please correct the budget. 30 $ is OK and I can give an offer for 30 USD, but because of your budget, it is not possible. Best Regards, Serdar Yalcin

€55555 EUR in 10 gün içinde
(21 Değerlendirme)
4.4
humayoonsheikh4u

DEAR SIR: I BID ON YOUR PROJECT DUE TO MY EXPERTISE ON M.S EXCEL I CAN DO YOUR PROJECT ON TIME WITH IN BUDGET. FURTHER DETAILS CAN SHARE ON CHAT. BEST REAGRDS

€250 EUR in 3 gün içinde
(12 Değerlendirme)
4.2
rra56100fe439f58

Hi, OK, I will do it for your budget. I can do the code/formula for you. It's a very basic formula. I don' need an hour to do that. I am an IT lecturer. See my work experience and titles held. I always go wit Daha Fazla

€250 EUR in 0 gün içinde
(12 Değerlendirme)
4.0
JLQ006

Give me the job I can do it in 1 hour. for $25. Give me the job I can do it in 1 hour. for $25. Give me the job I can do it in 1 hour. for $25.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(17 Değerlendirme)
3.8
abhi1326

Hello I understand that you are looking for someone prepare a macro for the data in your excel sheet. I have worked on Excel projects for other clients as well and delivered quality output on time. I will maintain g Daha Fazla

€250 EUR in 3 gün içinde
(10 Değerlendirme)
3.7
fayjur

Greeting! My name is FayjurRahman I am a Virtual Assistance. I would love to have opportunity to discuss your project with you. My Skill: - Data analysis/entry into Excel, Word or other programs - Research usi Daha Fazla

€300 EUR in 10 gün içinde
(7 Değerlendirme)
1.7
blitz003

well, based on the amount you specified that's the lowest I could bid, but I'll take 30$ if that's what you'll pay. I'll need a bit more details. Let's talk

€277 EUR in 10 gün içinde
(1 Yorum)
1.2
AnilTitusJacob

Hi, ***THIS WORK IS DONE*** SAMPLE FILE IS READY IN MY PORTFOLIO. ( I have over 10 years of industry experience with Excel and VB programming in Excel. Now I am teaching VB programming in Excel. The task that you Daha Fazla

€250 EUR in 0 gün içinde
(2 Değerlendirme)
1.2
bhagwansahane89

am ready to start now...come on chat

€250 EUR in 0 gün içinde
(0 Değerlendirme)
0.0
LoiCurry

I previously worked at sportsbook company but i decided to resign and work at home. I've also worked as an encoder that's why i can do data entry jobs. I'm a hardworking person and not easily to give up and I can work Daha Fazla

€555 EUR in 10 gün içinde
(0 Değerlendirme)
0.0