You can define boundaries through a combination of `MID`

, `FIND`

, and `LEFT`

; here’s how.

## Step 1

First, isolate the only the text starting with the city; this will include the rest of the string as well.

```
MID(
{Address},
FIND(
"City:",
{Address}
)
+ 6, 50
)
```

## Step 2

Then, use another similar formula to extract *just* the city name from the result of the above formula. In this step, you'll need to include the entire formula used above as part of another formula. I'll include that as a placeholder (INSERT FORMULA FROM STEP 1) for now.

```
LEFT(
INSERT FORMULA FROM STEP 1,
FIND(
"State:",
INSERT FORMULA FROM STEP 1
)
-1
)
```

## Step 3

Replace the placeholder (INSERT FORMULA FROM STEP 1) with the actual formula from step 1. When combined together, the entire formula would be:

```
LEFT(
MID(
{Address},
FIND(
"City:",
{Address}
)
+ 6, 50
),
FIND(
"State:",
MID(
{Address},
FIND(
"City:",
{Address}
)
+ 6, 50
)
)
-1
)
```

Here’s a screenshot showing the final result:

Hope that helps!