Forum Discussion
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...
Thank you so much for your solution.
I tried the three solutions but i am getting the below errors for the reasons where the names are not available. but it works for the ones with the salutation, but if there are multiplenames it wont be replaces. could you able to help with that