Forum Discussion

dev814's avatar
dev814
Regular Visitor
5 years ago
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...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi dev814 ,

     

    Try this:

     

    Best regards

    Icey

     

    If this post helps, then consider Accepting it as the solution to help other members find it faster.

Icey's avatar
Icey
Community Support
5 years ago

Hi dev814 ,

 

Try this:

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.