I need several Excel sheets reduced for ranges of sequential numbers.
I need a formula, formulas or script to do the following using Excel:
The numbers are zip codes and are currently entered cell by cell, (without the 's)
I need all values sorted smallest to greatest
I need any 6th, 7th, 8th, or 9th digit in the cell removed without altering the first 5 digits  becomes 
I need all leading zeros to stay in place, resulting in 5 digit codes.
I need to find all ranges that are inclusive and redux the cells to be
I need it further reduced to a single cell entry with all values comma separated [00001,00003-00005]
I have 40-50 sheets that need to be done so I'm looking for a repeatable process, not just a solution to the attached sheet. Please use the attached sheet as an example
17 freelancers están ofertando el promedio de $115 para este trabajo
Hello. i am expert in data entry work. i can do your project. i will provide you good , accurate and quality work. i am quick learner and i can do fast work. Thanks Saidul