I have the following data in column K in bookings sheet.
Dj Ian Duggan
Dj Ian O Sullivan
Jason Nolan Apple Computers
Ingrid Homich Cork International Hotel
Mary Foley Mobile
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
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
41 freelancerów złożyło ofertę na kwotę €1664 do tego projektu
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 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
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
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.