Sorting

cofsub · May 2nd, 2002, 09:01 AM

I have a list of zip codes in a column, there are ones with the extra 4 digits, how do you sort putting these with extra digits into proper order?
28719
28779
28717-9300
28776-4293

eliW · May 2nd, 2002, 10:48 AM

Quote:

On 2002-05-02 08:01, cofsub wrote:
I have a list of zip codes in a column, there are ones with the extra 4 digits, how do you sort putting these with extra digits into proper order?
28719
28779
28717-9300
28776-4293

Hi cofsub,
Simple idea:
1) add another column next to the zip codes lets say B
2) In B1 put =LEFT(A1,5) and drag this formula until last row of codes
3) Now sort on B
4) Delete row B
Regards,
Eli

cofsub · May 3rd, 2002, 09:12 AM

thanks i'll try that, but for now just addedd -0000 to those without four digits and sorts like we want.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 2nd, 2002, 09:01 AM	#1
cofsub New Member Join Date: May 2002 Posts: 2	I have a list of zip codes in a column, there are ones with the extra 4 digits, how do you sort putting these with extra digits into proper order? 28719 28779 28717-9300 28776-4293

May 3rd, 2002, 09:12 AM	#3
cofsub New Member Join Date: May 2002 Posts: 2	thanks i'll try that, but for now just addedd -0000 to those without four digits and sorts like we want.