Excel Data Manipulation of Product Descriptions (HTML) Using an Excel VBA Formula
- or -
Post a project like this$$
- Posted:
- Proposals: 13
- Remote
- #1531879
- Expired
Customer Support, Bookkeeping, Data entry, Product listing, Virtual assitant
Coimbatore
Virtual Assistant, Excel programmer, Customer Support Agent, EN-GR/GR-EN Translator
Kornos
Google sheets apps script GAS VBA Excel Macro VB.NET ADD-INS Web Scrap API developer
Kharkiv
Excel VBA, MS PRoject Expert, Web Scraper, Arena, Simulation, Spreadsheet, Wordpress customisation
Istanbul
989841140713652755450107454111058521119279812091871230158130044914005531474246
Description
Experience Level: Intermediate
I have an Excel document that contains product descriptions for our Shopify store, which is currently cluttered with HTML that I no longer require. I would like someone to format the data in Excel, removing the HTML and keeping the basic product description.
From my understanding a VBA formula would solve this problem?
Please see the file attached and when replying please can you show me an example so I know you can do this job effectively.
I.E. Cell C2 should be as below instead of as in the Excel document...
2004 - 2009 Land Rover Discovery 3 Lower Tailgate In Cairns Blue LRC849
Paint Code: LRC849 Blue
I am looking to start the job immediately if I can see you are capable of completing it.
Thank you.
From my understanding a VBA formula would solve this problem?
Please see the file attached and when replying please can you show me an example so I know you can do this job effectively.
I.E. Cell C2 should be as below instead of as in the Excel document...
2004 - 2009 Land Rover Discovery 3 Lower Tailgate In Cairns Blue LRC849
Paint Code: LRC849 Blue
I am looking to start the job immediately if I can see you are capable of completing it.
Thank you.
Harvey W.
100% (8)Projects Completed
6
Freelancers worked with
4
Projects awarded
14%
Last project
23 Dec 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Can not find "Paint Code: LRC849 Blue" text in the attached file. If this has to be added what is the logic?
-
Hi Harvey,
The description in Cell C2 of your example data contains a lot of text.
What logical approach did you use to end up with only 2 lines of text obtained from that cell?
Thanks
Kris
-
Hello, Your attached file is a link and I am not able to download it. would you please send me main file then I am able to give you a solution. I can check it and I believe I can make a macro to solve this problem.
Regards,
407069388120387186
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