Our county road data has road names for all roads in the county. In the attribute name field, there are some entries with all uppercase for the road name and some with mixed case. I would like to go about switching the road name attributes all to mixed case just for uniformity throughout the county data.
How can this be done?
I know I could assign someone to manually edit every record into Mixed Case, but I'd like to try to perform this as one single efficient process if possible.
I've looked into Field Calculator and it looks like there could be an answer there, but I'm having trouble identifying which of the processes would work. I don't mind exporting it and working the table in Excel and then rejoining it after it's cleaned if that's truly the best way. We have 33,906 road segments.
I've attached some screenshots as examples.