Put CSV Zip Codes into Zip Code Ranges

[84thsav]

I have a list of about ~13,000 zipcodes in csv format (15002,15003,15004,15005,15006,15007,15009,15010) that i need to put into zip ranges (15002-15007,15009-15010)

I realize i can do this manually but that takes a lot of time and i mean who wants to do that! I cant figure out a method or a formula for this one.

Id appreciate any feedback Thank you

A1	A2	A3	A4	A5
15002	15003	15004	15005	15006

Would turn into the below format

A1	A2	A3	A4	A5
15002	15003-15006	15007

 

[Peter_SSs]

@84thsav
Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

If you have posted the question at more places than mentioned in post #4 above, please provide links to those as well.