I have data in a column that looks like the below example:
El Monte CA
I need to move the last 2 characters to a separate column. Which function in the field calculator will deliver those results?
Use the Right Function
Right( [textField], n ) (where n is the number of characters)
Right(“abcdefg”, 3) = “efg”
This is pretty handy for learning how to use the field calculator http://www.esri.com/news/arcuser/0405/files/fieldcalc_1.pdf