Removing multiple names from a text in a column

I have a column named exception reason which is in text fomat,  within this text there will names of people which will be starting by Mr, Mrs, Miss or Ms, there could be multiple names in a single te...