Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

How to break or split addresses

133 1
Showing results for 
Search instead for 
Did you mean: 

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!

1 Reply 1

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.