Database sorting

[evelynminnie]

I need to have our mailing vendor sort database to EXCLUDE street addresses

Data base is as follows with each heading being a different column. Vendors
format is

Last Name First Name Address City State Zip

iF i CHANGE THE DATABASE TO THE FOLLOWING WILL THE STREET ADDRESSES BE
EXCLUDED?
-- Last Neme First Name Address with City, State & Zip all in one column.

I was told by the rep that to exclude the street address, I would have to
match their format. The new rep is now stating that it's ok to have the
street address along with the city, state and zip and that the exclusions
will still be made.

Please help! This has become an issue on my job and my boss thinks I'm lying.
re

 

[Joel]

It is very diffficult to seperate out the address from the city state and zip
code. The simpliest solution wuld be to extract the zip code from the rest
of the address and sort by zip code. For mailing puposes only zip code
sorting is required. City names don't work in NJ because we have something
like 7 different Washington Townships in the same state. Also the same zip
code can be used for 5-7 different town names. The zip code is the last 5
character on the line so something like =text(right(B5,5),"@") which will
remove the zip code and keep the number as text so the leading zero in NJ zip
codes doesn't get dropped.