Thanks for all the input and help. I was able to use 3 iterations of the !Address![:!Address!.rfind(' ')] formula to slice off the zip, state, and city. This left me with just the street address, which is all I needed. The tough part was that there were just spaces separating everything so it took some finagling to get the city's sorted out but I finally got it. Leaving a comma between the address, city, state, and zip would have made it much easier.
... View more