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)




[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



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

Habilidades: Entrada de datos, Procesamiento de datos, Excel

Ver más: excel 2000 macros work excel 2007, excel helphow can sum cells sheet, article submission work excel, data entry, data processing, excel, data entry data processing, microsoft 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

Información del empleador:
( 0 comentarios ) Escondido, United States

Nº del proyecto: #12155148

Adjudicado a:


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 Más

$90 USD en 3 días
(48 comentarios)

17 freelancers están ofertando el promedio de $115 para este trabajo


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 :- Más

$150 USD en 3 días
(279 comentarios)

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 Más

$176 USD en 3 días
(12 comentarios)
$140 USD en 0 días
(116 comentarios)

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 Más

$176 USD en 1 día
(170 comentarios)

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 Más

$150 USD en 3 días
(167 comentarios)

A proposal has not yet been provided

$176 USD en 3 días
(74 comentarios)

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 Más

$105 USD en 2 días
(55 comentarios)
$49 USD en 1 día
(127 comentarios)

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

$100 USD en 1 día
(110 comentarios)

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 Más

$72 USD en 1 día
(45 comentarios)

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. Más

$98 USD en 3 días
(78 comentarios)

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 Más

$100 USD en 1 día
(66 comentarios)

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 Más

$70 USD en 3 días
(40 comentarios)

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 en 3 días
(24 comentarios)

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 Más

$105 USD en 1 día
(14 comentarios)

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

$100 USD en 0 días
(5 comentarios)

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 Más

$88 USD en 0 días
(0 comentarios)