Is This Content Helpful?
We're glad to know this article was helpful.
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 the Attribute Table.
Follow the steps below.
The procedure described below is for Version 9.3x and earlier.
Optionally, create a new text field for the result by first clicking Options > Add Field.
Dim sUpperC As String
sUpperC = LEFT( [FIELD_NAME], 1)
Dim sLowerC As String
sLowerC = RIGHT( [FIELD_NAME], LEN( [FIELD_NAME]) - 1)
Dim Output As String
Output = UCASE(sUpperC) & sLowerC