Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
123
Views
Topic starter
I have this query in which I need to break into 2 different columns. One for Salutation (Mr. and Mrs.; Ms. or Mr.) and the other for the first name.
I have tried splitting columns base on different delimiters, but can't seem to get it the way I want it. M code is out of my league, so any help the attached file would be much appreciated.
Thanks,
Ken Mc
Posted : 26/02/2019 6:54 pm
Hi Ken,
There's not really an elegant way to do this because the names are not consistently formatted. See attached.
Mynda
Posted : 26/02/2019 8:18 pm
Topic starter
Hey Mynda,
That was what I had problems with, but this will work perfectly. I will finish off on the table.
I sincerely appreciate your help with this.
Ken Mc
Posted : 27/02/2019 12:31 pm
