Find Jobs
Hire Freelancers

Do some Excel Work

$30-150 USD

Abgeschlossen
Veröffentlicht vor mehr als 7 Jahren

$30-150 USD

Bezahlt bei Lieferung
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
Projekt-ID: 12155148

Über das Projekt

17 Vorschläge
Remote Projekt
Aktiv vor 7 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
Vergeben an:
Avatar des Nutzers
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, Balint Kolosi
$90 USD in 3 Tagen
4,9 (48 Bewertungen)
5,1
5,1
17 Freelancer bieten im Durchschnitt $115 USD für diesen Auftrag
Avatar des Nutzers
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 :-) Sincere regards, AsHFAK
$150 USD in 3 Tagen
4,8 (279 Bewertungen)
7,6
7,6
Avatar des Nutzers
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 the Philippines, we continually bring knowledge and new ideas to them. Forward thinking, resourceful professional, total client satisfaction defines our success. Just a quick introduction, with more than 10 years of experience in Sales, Marketing and Customer Service who understands that the power of a good relationship with customers and clients establishes a successful business and repeat sales. We have been offering Business Process Outsourcing Services to our clients and have built our business on quality services like Customer Service, Chat Support, Outbound sales, Article Writing, Data Entry, Data processing, transcriptionist, Lead Generation, SMM, VAs to name a few. We are highly skilled and smart professionals to deliver your project base on your requirements. English is highly used in my country and we speak good English. I have agents who have more than 7 yrs doing telemarketing, data entry, online research, lead mining, email handling and customer service experiences. We have been working as a team or individual projects for more than 3 years now and we mostly have clients here in Freelancer. We have been practicing good team work, team effort, and integrity that's why we have good reviews (you may check it on the profile page). Cheers, JM
$176 USD in 3 Tagen
5,0 (12 Bewertungen)
7,1
7,1
Avatar des Nutzers
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 handle this job very well to your appreciation. I can find and extract the information from different websites into an Excel sheet. I am ready to hear the details of the project more in detail now. I have always created a long-term collaboration with my clients through hard work and quality output for a reasonable price. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
$150 USD in 3 Tagen
4,9 (167 Bewertungen)
6,6
6,6
Avatar des Nutzers
A proposal has not yet been provided
$176 USD in 3 Tagen
4,8 (74 Bewertungen)
6,4
6,4
Avatar des Nutzers
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 contact me to further discuss the details. Looking forward to hear from you, Kind regards, Chris (chriskerpini)
$105 USD in 2 Tagen
4,9 (55 Bewertungen)
6,4
6,4
Avatar des Nutzers
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 in 1 Tag
4,8 (110 Bewertungen)
6,0
6,0
Avatar des Nutzers
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 experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$100 USD in 1 Tag
4,9 (66 Bewertungen)
5,1
5,1
Avatar des Nutzers
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 & award Thanks
$72 USD in 1 Tag
4,9 (45 Bewertungen)
5,2
5,2
Avatar des Nutzers
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. Please contact me for more information.
$98 USD in 3 Tagen
5,0 (78 Bewertungen)
5,2
5,2
Avatar des Nutzers
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 this type of job where many types of string manipulation has been done. Please check my portfolio to see my work. So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra
$70 USD in 3 Tagen
4,9 (40 Bewertungen)
4,4
4,4
Avatar des Nutzers
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 in 3 Tagen
5,0 (24 Bewertungen)
4,4
4,4
Avatar des Nutzers
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 Marketing, Leads,Social Media,Telemarketing work would like to assure you that I will do my job according your expectation. I have a highly creative data entry studio. Just give me your jobs and find out me. Close communication & ON-TIME delivery ensures a long-term relationship with our valued clients. We believe, goodwill in business is worthier than anything else. I give you drafts and unlimited revisions until your satisfaction. I do through research on every project to get the Best result as well as optimum client satisfaction. Thanks
$105 USD in 1 Tag
4,9 (14 Bewertungen)
3,7
3,7
Avatar des Nutzers
Hi there! I am available right away and I can deliver this within 8 hours. Warm regards, Naseef U.
$100 USD in 0 Tag
5,0 (5 Bewertungen)
3,4
3,4
Avatar des Nutzers
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 career with the help of prominent service. Also Dedicate on project deadline. ready to start. 100% manually and valid work. so feel free. willing to discuss further for start now. Kind Regards by motin789
$88 USD in 0 Tag
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von UNITED STATES
Escondido, United States
0,0
0
Mitglied seit Nov. 22, 2016

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.