Do some Excel Work

Cerrado

Descripción

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

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, 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

ID de proyecto: #12155148

Adjudicado a:

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

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

17 los freelancers están ofertando un promedio de $115 para este trabajo.

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

$150 USD en 3 días
(279 comentarios)
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 Más

$176 USD en 3 días
(12 comentarios)
7.1
$140 USD en 0 días
(116 comentarios)
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 Más

$176 USD en 1 día
(170 comentarios)
6.9
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 Más

$105 USD en 2 días
(55 comentarios)
6.4
muzammil21

A proposal has not yet been provided

$176 USD en 3 días
(74 comentarios)
6.4
$49 USD en 1 día
(127 comentarios)
6.5
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 Más

$150 USD en 3 días
(167 comentarios)
6.6
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

$100 USD en 1 día
(110 comentarios)
6.0
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 Más

$100 USD en 1 día
(66 comentarios)
5.1
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. Más

$98 USD en 3 días
(78 comentarios)
5.2
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 Más

$72 USD en 1 día
(45 comentarios)
5.2
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 en 3 días
(24 comentarios)
4.4
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 Más

$70 USD en 3 días
(40 comentarios)
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 Más

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

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

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