I am trying to change the scheme of a primary road name for our EMS dispatchers. The attribute just contains the road number. For example, one of the counties I am working on the roads are label NC xxxx. However, the table that I use to label the end map only has the number. Is there a way to go into the field and append it with the 'NC' at the beggining without having to go in and do each one individually? Screen shot included. I want to change the column on top to what the bottom looks like without having to go through each one which is thousands.
