Is there a setting where upon entering into a field the data is highlighted?

In the use of "Proper (name)" in the calculated value of for a name field, names that use "O'" or "Mc" require a space before creating the capitolization of the second part of the name, ie, require "Mccabe" or Mc Cabe" but not "McCabe" -- is there way to refine this?

Is there a setting where upon entering into a field the data is highlighted?

There's a "select entire contents" checkbox in the field behavior options.

Your second question is one that has no simple answer, but a custom function such as this one might be worth a try.

This is a topic that comes up from time to time.

Take a look at the file attached to this Post:

Link (NameParseLynn.fp7)

Custom Function require the Advance Edition of FileMaker in order to create, and put into a file. A lot of time, the Custom Functions will work as a regular Calculation, but if they are a recursive, then it will not work. Your preference indicates that you have the Standard Edition, you could have a friend with Advance put the CF into your file.

HTH

Lee