- Street
- To extract just the "HouseNumber StreetName" from the address in the field 6129681994, use this formula in Airtable:
```
LEFT({6129681994}, FIND(",", {6129681994}) - 1)
```
This will return only the "HouseNumber StreetName" portion.
- City
- To extract the City from the address in the field 6129681994, use this formula:
```
TRIM(
MID(
{6129681994},
FIND(",", {6129681994}) + 2,
FIND(",", {6129681994}, FIND(",", {6129681994}) + 1) - FIND(",", {6129681994}) - 2
)
)
```
This will return only the City portion from the address.
- State
- To extract the StateCode from the address in the field 6129681994, use this formula in Airtable:
```
TRIM(MID({6129681994}, FIND(",", {6129681994}, FIND(",", {6129681994}) + 1) + 1, 3))
```
This will return the two-letter StateCode from the address.
- Zip
- To extract the Zipcode from the field 6129681994, use this formula in Airtable:
RIGHT({6129681994}, 5)