Forum Discussion
Solved
Eliminate middle initial from row
I have a large data set. I have a column with first names, however, some of the rows have first names that also include middle intials or middle names. Example... Mary A. Mary Ann I nee...
Have you tried the Column from Examples feature? Would likely work well for this.
Add a column from an example in Power BI Desktop - Power BI | Microsoft Docs
Regards,
Pat