Need code or function to remove text

[zubair99]

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

 

[synergy16]

nothing is highlighted yellow

 

[zubair99]

nothing is highlighted yellow

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

 

[zubair99]

please help someone I will appreciate.

 

[zubair99]

Please help me someone.

 

[Michael M]

As there is no logic to the text to be removed, I would suggest Text to Columns might be the best option.
Other posters might see a different method better than I