Instructions provided describe how to use the Field Calculator in ArcMap to capitalize the first letter of all the values of a text or string field in an attribute table.
This workflow and code sample only works for versions 10.x or later. This is because ArcGIS no longer supports VBA at Version 10. For 9.3.1 and earlier, please see the link in the Related Information section.
Optionally, create a new text field for the result by clicking the Options button in the top left of the attribute table and selecting Add Field.
sUpperC = LEFT( [FIELD_NAME], 1)
sLowerC = RIGHT( [FIELD_NAME], LEN( [FIELD_NAME]) - 1)
Output = UCASE(sUpperC) & sLowerC
Get help from ArcGIS experts
Download the Esri Support App