How to set a format on strings upon data import

[boknoval]

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

I hope somebody can help me with this.

[June7]

That is not setting a format, that is modifying the data.

You can do Find/Replace actions. Replace space with '. '

Replace & with '. & '

This might be able to be programmed but I've never done that and gets tricky. Would not want to modify 'Carter & Sons' with either of the above.

Think you are going to have to do manual edit and review each replace for correctness.

[boknoval]

oops sorry about that.. I'm not well versed with what the process is called.. hahaha

Ive tried that already and I think that wouldn't work.
you see some names have two initials, for example this data: J&T BOTIFAN -> it should be J. & T. BOTIFAN

[June7]

Right, J&T BOTIFAN would require both of the replacements. The first one to make T into 'T. '. Then the second to make & into '. & '