Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
TRYING TO ALPHBETIZE STREET ADDRESSES
I ALREADY LISTED ADDRESSES BUT NOW IT NEEDS TO BE ALPHBETIZE BY STREET NUMBER
AND NAME..HOW DO I GO ABOUT IT..SHOULD I START OVER?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
TRYING TO ALPHBETIZE STREET ADDRESSES
Anna
If you have the street number in one column and the name in another column, then sort the total range, first by street number and then by name (Data - Sort). Please post back if this is not clear. Clarify what you have. Where is the street number and where is the name? HTH Otto "ANNA" wrote in message ... I ALREADY LISTED ADDRESSES BUT NOW IT NEEDS TO BE ALPHBETIZE BY STREET NUMBER AND NAME..HOW DO I GO ABOUT IT..SHOULD I START OVER?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting street addresses | Excel Discussion (Misc queries) | |||
Help! How to sort addresses by street then by #...... | New Users to Excel | |||
Working with street addresses? | Excel Discussion (Misc queries) | |||
Problems copying street addresses and dates | Excel Discussion (Misc queries) | |||
Why is there a box symbol at the end of my street addresses in on. | Excel Discussion (Misc queries) |