I got this list from my boss with instructions to separate the city, state and zip from the street address.
Unfortunately, The person who entered the data originally did a poor job, so there are often two city, state and zips or
there is extra information after the zip or there is a dba included before the street address(which we don't need).
I already tried a formula to separate when 5 spaces in a row is discovered, after I formatted using the replace tool since
most of the street names and city, state and zip were separated by 2 or more spaces. This turned out inconsistent, forcing
me to check through the entire list fixing mistakes anyways.
I've attached examples of the original file and an
example of after I used my formula.
Again, what I need is company name in one column, street address in another,
and finally the city, state zip in a final column.
Here is the code I used
Hope you can help!
Thanks in advanced,