![]() Sort mixed zip codes with a helper column In this case, there is a list mixed with these two types of zip codes, the job is to sort the zip codes by first five basic digits as below screenshot shown, how can you quickly handle it? How to sort mixed zip codes (5 digits and 9 digits) ascending in Excel?Īs we know, there are two types of zip codes, one is 5-digits series, and the other is the 9-digits series.
0 Comments
Leave a Reply. |