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