ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   TRYING TO ALPHBETIZE STREET ADDRESSES (https://www.excelbanter.com/excel-discussion-misc-queries/116101-trying-alphbetize-street-addresses.html)

Anna

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??

Otto Moehrbach

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??





All times are GMT +1. The time now is 06:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com