Write some excel code to remove strings
€250-750 EUR
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
Proje NO: #10522298
Proje hakkında
Bu iş için 39 freelancer ortalamada €1734 teklif veriyor
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
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
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
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
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
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
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
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
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
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
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
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.
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
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
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
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
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