I'm trying to take a list of addresses and standardize them using a macro. Basically it's a bunch of replace commands at this point, but I'm having trouble with street names that contain the words I'm trying to abbreviate.
For example, I'm abbreviating East as E, but there are streets named...