进行中

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

About the Employer:
( 0 reviews ) Escondido, United States

项目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

17名威客为此工作的平均竞标价是$115

jubair7

Experienced FREELANCER HERE to work for your project. Let's discuss more and finalize the project and cost. Feel free to ask me questions, if any. I look forward to work with you. Have a good day and stay safe :- 更多

$150 USD 在3天内
(279条评论)
7.6
jkaranm

Hi! Our business is to make yours effective & efficient. We have a sound understanding of our Clients’ operations and corporate goals. As one of the pioneer professionals in the outsourcing/call center industry in 更多

$176 USD 在3天内
(12条评论)
7.1
$140 USD 在0天内
(116条评论)
6.7
Webxpert4u

Hello, I can create macro to perfrom your all small tasks in all 40-50 excel files. Please send me all filles. Highly experienced in Excel Programming, Excel automation and Macros. I am good at Visual Basic and .net 更多

$176USD 在1天里
(170条评论)
6.9
mirniyazuddin92

Dear Sir/Ma'am, I have sent sample to Scarlett R. Kindly request him to check my sample.. I am a Excel, Web research, Data Entry & Webs Scrapping expert. I checked and understood your requirements. I can han 更多

$150 USD 在3天内
(167条评论)
6.6
muzammil21

A proposal has not yet been provided

$176 USD 在3天内
(74条评论)
6.4
chriskerpini

Hello, My name is Chris. As you can see from my profile, I have 16+ years experience working with Excel/VBA and 13 years teaching them both (all levels). I can certainly do excellent work with your project. Please c 更多

$105 USD 在2天内
(55条评论)
6.4
$49USD 在1天里
(127条评论)
6.5
redouaneaberdin

Hi there, My name is Redouane. I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you

$100USD 在1天里
(110条评论)
6.0
atifdar

Hi there, MS Excel expert here I've read the project description and check the attached sample spreadsheet and very confident that will deliver 100% as per requirements in low cost Feel free to discuss further & aw 更多

$72USD 在1天里
(45条评论)
5.2
vlayausa

Hello, I am proficient with Excel and VBA and I could write a script that would do what you require. So, it could be used on all 40-50 sheets. I have a lot of experience and I can guarantee speed and accuracy. 更多

$98 USD 在3天内
(78条评论)
5.2
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex 更多

$100USD 在1天里
(66条评论)
5.1
vsprybhanu

Hi, Experienced Excel VBA and VB.Net Programmer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating Strings and Numbers between sheets. I mostly completed th 更多

$70 USD 在3天内
(40条评论)
4.4
Saidul28

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

$117 USD 在3天内
(24条评论)
4.4
LancerBSL

Hello I am Asaduzzaman Apu I see your project and i do it as your acceptation.I have 3 years experience to work in a any kind data process Web Scraping, Web Search, Excel,Affiliate Marketing, Email Marketing, Internet 更多

$105USD 在1天里
(14条评论)
3.7
naseefo

Hi there! I am available right away and I can deliver this within 8 hours. Warm regards, Naseef U.

$100 USD 在0天内
(5条评论)
3.4
motin789

please knock me for solution... Dear Sir/Madam, Thanks for Your Clear Project Descriptions. I am a Professional & Authentic Freelancer. I'm very interested to do your job. I have a dream to establish My online 更多

$88 USD 在0天内
(0条评论)
0.0