Airtable Sync App

Personal Info

Street: 301 South Kenmore Avenue
City: Arlington
State: To extract just the StateCode from the address in the field "301 South Kenmore Avenue," use this formula in Airtable: ``` TRIM(MID({301 South Kenmore Avenue}, FIND(",", {301 South Kenmore Avenue}, FIND(",", {301 South Kenmore Avenue})+1)+2, 2)) ``` This will return only the two-letter StateCode.
Zip: To extract just the Zipcode from the address in the field "301 South Kenmore Avenue," use this formula in Airtable: RIGHT({301 South Kenmore Avenue}, 5)

Street: 301 South Kenmore Avenue
City: Arlington
State: CA
Zip: To extract the Zipcode from the address in the "301 South Kenmore Avenue" field, use this formula in Airtable: RIGHT({301 South Kenmore Avenue}, 5)