I have a CityState field that has the city and states of landowners. Bellingham WA, for example. I am making two new fields, OwnerCity and OwnerState in which I strip the last two characters of CityState for OwnerCity (RTrim([CityState],2) and capture the last two characters for OwnerState (Right([CityState],2). Some of the CityState cells are empty, so I can't run the calculator.
What can I add so that it runs the calculation where there is text, and keeps the value empty if there is not any text? I'm sure there's an easy answer to this, but I have't figured it out yet.