Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Database sorting
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Database sorting
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. "evelynminnie" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
How to make reference to database and if true copy from database? | Excel Discussion (Misc queries) | |||
Two problems sorting a database containing pictures | Excel Discussion (Misc queries) | |||
Two problems sorting a database containing pictures | Excel Discussion (Misc queries) | |||
Excel as a database and sorting information | Excel Discussion (Misc queries) |