- Street
- To extract just the "HouseNumber StreetName" from the address in the 310.50 field, use this formula in Airtable:
```
LEFT({310.50}, FIND(",", {310.50}) - 1)
```
This will return everything before the first comma, which is the "HouseNumber StreetName".
- City
- To extract the City from the address in the field 310.50 (formatted as "HouseNumber StreetName, City, StateCode, Zipcode"), use this formula in Airtable:
```
TRIM(
MID(
{310.50},
FIND(",", {310.50}) + 1,
FIND(",", {310.50}, FIND(",", {310.50}) + 1) - FIND(",", {310.50}) - 1
)
)
```
This will return just the City portion.
- State
- To extract the StateCode from the address in the 310.50 field (formatted as "HouseNumber StreetName, City, StateCode, Zipcode"), use this formula in Airtable:
```
TRIM(MID({310.50}, FIND(",", {310.50}, FIND(",", {310.50}) + 1) + 1, FIND(",", {310.50}, FIND(",", {310.50}, FIND(",", {310.50}) + 1) + 1) - FIND(",", {310.50}, FIND(",", {310.50}) + 1) - 1))
```
This will return the StateCode portion of the address.
- Zip
- To extract the Zipcode from the "310.50" field, use this Airtable formula:
```
RIGHT({310.50}, 5)
```
This assumes the Zipcode is always the last 5 characters of the address.