Find Jobs
Hire Freelancers

VBScript Excel string manipulation. Adding to existing working Macro.

$30-250 AUD

Slutfört
Publicerad över tre år sedan

$30-250 AUD

Betalning vid leverans
Hello, I worked for many years in I.T, and as part of my role I learned VBScript. I left I.T around 6 years ago, and over time I have continued to write scripts to help in my business. Now I am lacking time to write the VBScript, so I am looking for an experienced VBS programmer to help with some changes to an existing VBScript. I am rusty with not using my VBS skills, and I am finding that it is too slow going! I have an existing VBScript for Excel that takes data from an Excel worksheet, and then manipulates the data by removing and sorting columns, and also modifying data in the spreadsheet. The columns are formatted perfectly, and now there is some additional string manipulation needed. Example of string manipulation within For loop - Check each cell in a column, and modify then extract data from address string e.g "123 Example Street, San Roque, 1801, NCR, Philippines, The" Tasks: - Change 'Philippines, The' to 'The Philippines'. i.e If there is ", The" in the string remove ", The" and add "The " in front of country - Extract location with state. e.g in the example above extract location as "San Roque, NCR" - Extract country name and write to a cell Full instructions will be provided once the candidate has been accepted. Some of the VBS functions that you should be familiar with: Left, Right, Replace, InStr, InStrRev I am looking for someone with good experience with writing VBScript macros in Excel, who works quickly and know what they are doing. On selection of the right candidate I will provide the existing XLSM file along with example data to work with.
Project ID: 26931354

Om projektet

9 anbud
Distansprojekt
Senaste aktivitet fyra år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
Tilldelad till:
Använd avatar
$0 AUD Om 5 dagar
4,9 (63 omdömen)
6,6
6,6
9 frilansar lägger i genomsnitt anbud på $148 AUD för detta uppdrag
Använd avatar
I'm an Excel/Excel VBA expert with rich experience in Excel/VBA application. I read the job details extremely carefully. I am absolutely sure that I can do this project very well. I'm ready to do it now. I will wait for your positive response. Thank you.
$100 AUD Om 1 dag
5,0 (2 omdömen)
2,8
2,8
Använd avatar
Hello I have just saw your project and it's very cool to work over there we have 500+ trusted clients please give a chance to work on your project inbox me for further details
$100 AUD Om 2 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
I'm developer since long and solving such problem almost on regular basis,, on few prestigious site ,, and I'm confident enough that I can handle & fix it,,, but on other side I also need complete information,,, what exactly are your need along with the expected output, to avoid any successive issue. Please check my profile & portfolio, will help you to make decision. Rajesh S.
$150 AUD Om 5 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
I am a professional with all the experience and skills for project. Data Entry is one of the skills we have and can help you with the project as per your project.
$140 AUD Om 7 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
MOSTLY I DONE EXCEL SHEET PROCESSING AND AUTOMATION USING MACRO. If you give chance I assure, i will do my best to finish your job as per your requirement. Thank you Relevant Skills and Experience I done excel sheet processing for college like NBA, publishing details and so on
$89 AUD Om 3 dagar
0,0 (0 omdömen)
0,0
0,0

Om kunden

Flagga för AUSTRALIA
Watsons Bay, Australia
5,0
1
Verifierad betalningsmetod
Medlem sedan maj 21, 2016

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.