Hello all. Need some help with the following; note that I am not a heavy MS
Office user.
I recently started receiving work-orders via spreadsheet. Data consists of
acct. numbers, names, addresses and phone info. I need info first sorted by
zipcode then by address. It is in the addressing fields that I'm having
problems.
For example, say I have the following addresses
10 E. 101 st
40 Garrett St
123 Main St
100 E. 105 St
3005 E. 83 St
111 Willis St
1400 Smith St
3005 E. 83 St
After a sort, I end up with the following order:
10 E. 101 st
100 E. 105 St
1001 E. 103 St
111 Willis St
123 Main St
1400 Smith St
3005 E. 83 St
40 Garrett St.
I need to keep the "E."(East) street addresses in contiguous order, but
can't seem to do so. I realize it's sorting on the house numbers. Is
there any way of sorting the way I want it without re-editing multiple
pages of document(s). Any help greatly appreciated. TIA
The NOSPIN Group is now offering Free PC Tech
support at our newest website:
http://freepctech.com
|