How to break or split addresses

I’ve got a massive mailing list that has the entire address in one “address 1” field. To make matters worse, there is no uniformity to how the “address 2” section is written. There are STE, Suite, suite, and SUITE.

In an ideal world I can extract everything after a STE, Suite, suite, or SUITE designation and copy it into another field. Then I would like to delete all of the “address 2” text from the Address 1 field. Is this possible? I’m open to using google sheets or excel if need be.

Thanks for your time!

Figured it out in google sheets. Lots of find and replace + “split text into column”

For those interested, this video helped me understand the approach needed to chunk data and move it into other fields, even though this is a video based in excel.

1 Like