Write some excel code to remove strings

Closed Posted 7 years ago Paid on delivery
Closed Paid on delivery

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

Data Entry Data Processing Excel

Project ID: #10522298

About the project

39 proposals Remote project Active 7 years ago

39 freelancers are bidding on average €1734 for this job

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 More

€250 EUR in 1 day
(783 Reviews)
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 More

€250 EUR in 2 days
(254 Reviews)
7.6
zebracaro

I can do it for you quickly and exactly .

€250 EUR in 3 days
(117 Reviews)
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 More

€250 EUR in 3 days
(279 Reviews)
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 days
(56 Reviews)
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 More

€250 EUR in 1 day
(42 Reviews)
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 More

€250 EUR in 1 day
(82 Reviews)
5.8
sergpooh

I'll do it for $30 .

€250 EUR in 1 day
(42 Reviews)
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 days
(115 Reviews)
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 More

€555 EUR in 10 days
(50 Reviews)
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 days
(21 Reviews)
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 days
(12 Reviews)
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 More

€250 EUR in 0 days
(12 Reviews)
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.

€250 EUR in 1 day
(17 Reviews)
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 More

€250 EUR in 3 days
(10 Reviews)
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 More

€300 EUR in 10 days
(7 Reviews)
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 days
(1 Review)
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 More

€250 EUR in 0 days
(2 Reviews)
1.2
bhagwansahane89

am ready to start now...come on chat

€250 EUR in 0 days
(0 Reviews)
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 More

€555 EUR in 10 days
(0 Reviews)
0.0