The instructions provided describe how to use the ArcMap Field Calculator to convert an uppercase, lower case or mixed case string to a proper case string. For example, a string is in one of the following formats:
For best results, use the Python expression option. The following example shows a way to convert words so that each word has the first character capitalized and the rest of the letters in lowercase. The Python function .title() is used in the workflow to achieve this objective.
It is possible to convert a string to proper case by using Field Calculator on the desired field itself. However, it is recommended that a new field be created, rather than editing and using an existing field. This allows users to preserve the original data as a field calculation cannot be undone when performed outside an edit session.
Note: For information on equivalent steps in a label expression, or on performing this calculation in the ArcMap 9.3.1 or earlier Field Calculator, please see the link in the Related Links section below.