Im trying to sort some street addresses in alpha on excel 2007. I have a few formulas Im using to make it a little easier.BUT is there a simple fast and easy way to sort my data? I have over 30,000 Addresses to sort for an upcomming election. So if anyone has a formula or simple easy way to sort my data send me a message. Thanks.
Examples of Street Addresses.
106A CHARLES ST
#2A SURPRISE AVENUE
LOS ATTAJOS VILLAGE
1/4LP SURPRISE AVENUE
 |
