Excel How to Sort Addresses by zip code when they are in the same column?

all the addresses are in this format in the same column (B)

how can i sort them by the zip code and not the home number?

There are over 400+ cells to do it manually. HELP

3103 Forest Rd, Raccoon City, KY 98765Excel How to Sort Addresses by zip code when they are in the same column?
Hi,

The easiest thing to do is convert the single column into three separate ones. You can do this fairly easily using the Text to Columns feature:

1 - Select column B

2 - From the menu choose Data -%26gt; Text to Columns

3 - On the first page of the dialog choose Delimited and then click Next.

4 - Tick the box next to Comma (and uncheck Tab) and click Next.

5 - Click Finish

You should now have Home Number and Street in column B, Town/City in column C and Zip code in column D. You can now sort the entire table by column D.

Hope it helps.

EDIT:
@Greg - cheers for that! I didn't realise that the ZIP code and state code were separate parts. I'm in the UK, our postcodes include letters and numbers e.g. SK13 1AB where the SK is an abbreviation of Stockport.
**Thank you all very much!! ** =)

Report Abuse

Excel How to Sort Addresses by zip code when they are in the same column?
Cookiehead is right. Just to add one last thing to his answer:



Since there isn't a comma between the state abbreviation and the zip, then you'll need to do a second Text to Columns operation on the KY 98765 (how Kentucky has a zip starting with a 9 is another story.. lol) column, using a space as the delimeter, separating ST and Zip.



After you do that, then you can sort the table by your zip code column.Excel How to Sort Addresses by zip code when they are in the same column?
You can't. Sorting works from left to right.

Like the other guy said, you need to separate the data into different columns.
=right(b4,5) where B4 contains the whole address. This will return only the zip in a text format.