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 need to eliminate the middle intial/name from the row.  It has to be first name only in the first name column.