Do some Excel Work
该项目成功由kolosibalint ，以$90 USD的价钱在3 天内完成。为像这样的项目获取免费报价
项目预算$30 - $150 USD
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
- The New York Times
- Wall Street Journal
- Times Online