已完成

Do some Excel Work

该项目成功由kolosibalint ,以$90 USD的价钱在3 天内完成。

为像这样的项目获取免费报价
雇主工作
项目预算
$30 - $150 USD
完成于
3 天
全部竞标
18
项目描述

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)

[00001]

[00003]

[00004]

[00005], etc

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 [123456] becomes [12345]

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

[00001]

[00003-00005]

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

在寻找赚取金钱的机会?

  • 设定您的预算和时间框架
  • 大致描述您的建议方案
  • 为您的工作领取工资

雇用同样在该项目上竞标的威客

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online