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?