Capitalize the first letter of the values in a text field of a table in ArcGIS Pro

Summary

When viewing a table in ArcGIS Pro that has text values in all lower case, it may be necessary to capitalize the first letter of the text values through a quick and automated method. In the example shown in the screenshot below, the text values in the DelawareCounties table's CountyName field contain all lower case letters, and an adjustment must be made to capitalize the first letter of each word. For example, "new castle" becomes "New Castle".

The instructions provided below show how to capitalize the first letter of each word of the text values in a table field in ArcGIS Pro, using the the DelawareCounties layer table's CountyName field.

Procedure

1. Open the Calculate Field tool.
2. Set the Input Table parameter to the table that contains the text values to adjust. In this example, in this example, the DelawareCounties table.
3. Set the Field Name (Existing or New) parameter to the field that has the text values. In this example, the CountyName field.
4. Set the Expression Type parameter to Python.
5. Under Expression, select the field from the Fields list, and select the .title() function from the Helpers list. In this example, the CountyName field.

Note:
If a text value has multiple words and only the first letter of the first word must be capitalized, select the .capitalize() function from the Helpers list instead.

The general expression is as follows:

!<field name>!.title()

In this example, the expression reads: 

!CountyName!.title()

6. Click Run.
   • Once the Calculate Field tool finishes running, note that in the table shown below, the first letter in each word of the text values is now capitalized.