How do I correctly sort a list of zip codes that has both 5-digit.

V

vince48

How do I correctly sort a list of zip codes that has both 5-digit zip codes
and nine-digit zip+4 codes?
 
N

Norman Jones

Hi Vince,

Assume the zip codes populate cells A1:A100.
Use a helper column, say column B. In B1 enter the formula
=len(A1)
and copy down to B100. Then sort A1:B100 by Column B and then Column A.
 
R

Ron Rosenfeld

How do I correctly sort a list of zip codes that has both 5-digit zip codes
and nine-digit zip+4 codes?
Click to expand...

How are the codes stored? Are they numbers with a custom formatting; text
strings; or some combination?


--ron
 
M

Myrna Larson

I would use a helper column with a formula like this

=IF(ISNUMBER(A1),TEXT(A1,"00000"),A1)

Then sort on this column. That will generate this order

10021
10021-0123
10022
10022-0123

etc.
 
Top