There has to be an easy way to do this....

I have a column with first name, space, middle initial, period, space, last name. When I try and use the "RIGHT" function to look for the first "space" it's returning some of the last name..... I posted this question a minute ago, but might not have explained it enough. I want to delete the middle initial, and period from the column, leaving just the last name. Is that something that can be done?