FAQ How do you parse a City/State/Zip field?  Format the "Delivery Address" field and "City/State/Zip" field in your list. Next add separate "City," "State," and "Zip" fields in your list using the Modify feature under the database menu. If your new "ZIP" field is at least 9 characters long, the +4 Code will be added automatically (if 10 characters, a hyphen will be added). Otherwise, format a separate "Plus4" field if you want the +4 Code appended to your list. Next, Select OK from the Master Format screen and Go from the Address Check Option screen. Address Check will verify that the data in your "City/State/ZIP" field is correct, then copy in into the new fields.