Zamknięty

Write some excel code to remove strings

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

Umiejętności: Wprowadzanie danych, Przetwarzanie danych, Excel

Zobacz więcej: rose international, paul words, hour of code, crowley sullivan, code agency

O pracodawcy:
( 45 ocen ) Cork, Ireland

Numer ID Projektu: #10522298

41 freelancerów złożyło ofertę na kwotę €1664 do tego projektu

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 Więcej

€250 EUR w ciągu 1 dnia
(518 Oceny)
8.1
€250 EUR w ciągu 1 dnia
(254 Oceny)
7.6
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 Więcej

€250 EUR w ciągu 3 dni
(178 Oceny)
6.7
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 Więcej

€250 EUR w ciągu 2 dni
(115 Oceny)
6.4
€555 EUR w ciągu 10 dni
(37 Oceny)
5.8
zebracaro

I can do it for you quickly and exactly .

€250 EUR w ciągu 3 dni
(77 Oceny)
5.9
AlexandrUKR

please clarify deadline & possible next steps .

€333 EUR w ciągu 5 dni
(12 Oceny)
4.9
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 w ciągu 10 dni
(40 Oceny)
5.1
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 w ciągu 10 dni
(105 Oceny)
5.5
sergpooh

I'll do it for $30 .

€250 EUR w ciągu 1 dnia
(40 Oceny)
5.2
ineedWorkJob

Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert desktop/web software/macro/ Więcej

€250 EUR w ciągu 1 dnia
(42 Oceny)
5.3
€277 EUR w ciągu 5 dni
(66 Oceny)
5.2
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 w ciągu 10 dni
(21 Oceny)
4.5
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 Więcej

€250 EUR w ciągu 1 dnia
(23 Oceny)
4.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 Więcej

€555 EUR w ciągu 10 dni
(46 Oceny)
4.5
€300 EUR w ciągu 2 dni
(39 Oceny)
4.7
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 w ciągu 3 dni
(9 Oceny)
4.0
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 Więcej

€250 EUR w ciągu 0 dni
(11 Oceny)
4.0
Slavuta

Hello! I have experience of over 20 years of working with EXCEL, VBA write programs of any complexity. If you need a macro to excel, i can do it. I need more information about your task.

€250 EUR w ciągu 3 dni
(14 Oceny)
3.9
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 Więcej

€250 EUR w ciągu 1 dnia
(14 Oceny)
3.9