Converting HTML and XML special characters into excel with a Macro
$2-8 USD / hour
Closed
Posted over 11 years ago
$2-8 USD / hour
I have exported (copy and paste) articles from thousands of website. I am not sure which language was the website, most likely HTML or XML. When I copied them into excel, some special characters arose; e.g. . I know this are special characters for apostrophes or accent. I would like to re-convert these special characters in the ones that are supposed to be.
The task is to create a macro that can convert these special characters into the normal ones. I attach a sample of the text I have. The real file will have around 20,000 lines, but I want a macro I can use in the future as well.
Thanks and best,
Marco
Marco,
We know what you want exactly.
All we want from you is the list of websites/sources where you have copied the data :-)
Please share them and award us the work. Many a thanks
I have done this before and also have years of experience writing macros. I have sent details via PM. Please let me know if you need further details. Thanks!
Greeting Client,
I have gone through your project and can help you with this.
I have an experience of over 7 years with excel,accessand vba.I have designed database and automated numerous reports using these tools
I will design a very robust project for you with highest level ofquality
Regards
Mukul
i'am informatic in my subject
i've no experience about this freelancer.com, but i know what u'r need
we need to change the character by macro so when the character wrote in excel, so the macro will change d character.
I didn't file any attached file with your project. Please send the file. I can create and give you a macro for such replacement that you can use again.
Thanks.
--
Rawat
Good day, Marco. I believe that I am a well-qualified person for this job. That is because I have some experience related Automation Excel Macro. So, I hope you choose me. Please trust me and assign this job to me. Thank you !