How To Set A Format On Strings Upon Data Import

I have a database where I need to import data from an excel file.

What my employer needs me to do is upon appending the data to a table which I named properties, under the field which I called owner, all the names should follow the correct format. Most of the inputted data does not follow the correct format.

The correct format of the names should be:
K. CURTIZ -> Where K is the initial of the First Name, it should have the '.' and a space before the Family Name

Here's an example of a data that is inputted incorrectly:
R OTTESON -> it should be R. OTTESON

another example where there are 2 names of 2 different persons, it should be inputted this way:
A. & J. PANAG

Mostly inputted incorrectly this way:
J&T BOTIFAN -> it should be J. & T. BOTIFAN