Find & Replace Words in EXCEL VBA
2026
$30
- Posted:
- Proposals: 25
- Remote
- #2126477
- Archived
MBA Global Business Strategy, Export Bussiness Developement, Study Methods Teacher, Excel Developer, Amateur artist, Seller,
Lima
Search Engine Optimisation(SEO) specialist, Proficient in excel macros, Customer care specialist ,It's time to cash in on traffic from google
Chennai
1025327239762823993331162458135545423518383616776498652368261235932013718272344144
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