How do you go about sorting addresses in Excel?

Answer by  XTC46 (394)

The easiest way would be to create a seperate column for each part of the address (name, street, apt, zip etc). You can then sort rows by those coumns by selecting the column, selecting sort, then telling excel to expand the selection area when it prompts you with that option.

Answer by  cjsmuz (162)

First enter your address elements (Apt./Box Number, Street, City, State, and ZIP) into separate columns. Make sure your first row has the column names. Select your table and then from the Data tab, Sort & Filter group, click on Sort. When the Sort dialog box appears, choose the columns you wish to sort by.

Answer by  KnightTristan (5)

First, click to select the column containing the addresses. Next, click "Data" on the pull-down menu and click the preferred sort option, for example "Sort Z to A".

Answer by  wordmaster (8)

Extract the data from the base cell following the first space into a new column. Then do the same thing to the next column etc... until you have all the data extracted into columns. You can use the MID function along with the SEARCH function.

Answer by  anandmalappuram (7)

Go to sort and select custome sort. After selecting custom sort, select column on which the address is. After selecting this give A to Z. This means you have to give alphabetical sorting. The sorting option will available at Home. It is on the top of right side we can see. Click on that option and sort it easily.

Answer by  eddkinyanjui (4)

Sort using a unique key field. In the case of the US address formats I would sort using the zip code and area code e.g. 90210-2545. It does not repeat.