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...
This is an example of what i am trying to achive, i need to find the names and replace it with a " * " so that names are removed, names will always be starting by Mrs, Miss, mrs, Ms which can help to find the names in the text
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.