How to Pull a House Number Out of an Address
One of the most common tasks associated with addresses, is how to pull the house number out of an address. First, create a new field in your data. Name it House_Number. Next, copy the parcel address into this new field. Then, if you haven't done so already, start an edit session. Open Field Calculator for House_Number. Using VBA type: split([field], " ")(0) This is telling the field to delete everything after the first space, giving you the house number. Happy GIS-ing! Lindsy Bentley