Do some Excel Work

已完成

描述

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

技能: 数据输入, 数据处理, Excel

查看更多: excel 2000 macros work excel 2007, excel helphow can sum cells sheet, article submission work excel, show project work excel, work excel file, contract work excel, online contract work excel, script excel spreadsheet macro read cells, data entry work excel, excel script copy paste cells macro, work excel database, excel vba paste csv cells, surf internet work excel, excel vba cut paste cells, excel macro fill empty cells

Project ID: #12155148

已悬赏给:

kolosibalint

Dear Sir/Madam, I have 4 years experience in Excel VBA programming. I can write a macro that will do the job and you will be able to use it on won your if this tasks comes up again in the future. Regards, Bali 更多

$90 USD 在3天内
(48条评论)
5.1