Find & Replace Words in EXCEL VBA
2039
$30
- Posted:
- Proposals: 25
- Remote
- #2126477
- Archived
Google sheets apps script GAS VBA Excel Macro VB.NET ADD-INS Web Scrap API developer
Kharkiv
Excel Spreadsheet | Word Processing | PowerPoint Presentation | Data Analysis | Data Entry | MIS reports | Access Database
New Delhi
Virtual Assistant, Excel programmer, Customer Support Agent, EN-GR/GR-EN Translator
Kornos
Excel | VBA | Macro | MS Access | MS Word | PowerPoint Program | .Net | C# | VB.Net
Bangalore
Excel VBA, MS PRoject Expert, Web Scraper, Arena, Simulation, Spreadsheet, Wordpress customisation
Istanbul
1041288144943311927982365449208270222356474541123487762361479188945413004492219721
Description
Experience Level: Entry
Find & Replace Words in EXCEL VBA
Task:
• Create VBA script to remove any additional spaces from a cell in a column (for example remove extra space from the following text “apple “ or “ apple”. However do not remove spaces in between of words for example “I like apples” – These spaces should not be removed.
• Create a VBA script in Excel to look up specific words from a column and delete/replace with another word from a different list. You will need to create 3 columns of this.
• Create an additional column that populates the results with a text similar to “Replaced” or “Not found” where a word has been deleted or replaced, as per 2nd task above
Requirements:
1. Your VBA script should be able to run through a high volume i.e. 20000 to 30000 lines in under 10mins
2. The text must match exactly with the text in replace list
3. VBA script should allow me to add as many text in the replace list. I will need to continue to add words
See example spreadsheet template for further information
Task:
• Create VBA script to remove any additional spaces from a cell in a column (for example remove extra space from the following text “apple “ or “ apple”. However do not remove spaces in between of words for example “I like apples” – These spaces should not be removed.
• Create a VBA script in Excel to look up specific words from a column and delete/replace with another word from a different list. You will need to create 3 columns of this.
• Create an additional column that populates the results with a text similar to “Replaced” or “Not found” where a word has been deleted or replaced, as per 2nd task above
Requirements:
1. Your VBA script should be able to run through a high volume i.e. 20000 to 30000 lines in under 10mins
2. The text must match exactly with the text in replace list
3. VBA script should allow me to add as many text in the replace list. I will need to continue to add words
See example spreadsheet template for further information
Joey K.
100% (2)Projects Completed
3
Freelancers worked with
1
Projects awarded
8%
Last project
1 Jul 2018
New Zealand
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Joey,
Is it done ?
Thanks
Sumit
SaS Technologies -
hey
What is your deadline?
703686703145
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies