I am using the ApplyMap Function to change the fields but some of the fields are not changing correctly. This is mostly occurring with the fields that have spaces between them.
For one of fields, I am trying to change to DeKalb, but I am getting some De Kalb.
Another field, I am trying to change to LaPorte, but I am getting some La Porte or Laporte.
I'm thinking this is because of trailing spaces.. but I'm not sure how to use the trim function within the applymap function.
