Help

How to break or split addresses

1149 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Dustin_Good
6 - Interface Innovator
6 - Interface Innovator

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
Dustin_Good
6 - Interface Innovator
6 - Interface Innovator

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.