Closed

Converting HTML and XML special characters into excel with a Macro

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

Skills: Excel

See more: excel xml special characters, xml excel special characters, convert xml special characters, excel macro html text, html special characters excel, excel html special characters, convert html excel xml, excel special, convert website xml, xml excel, macro e, excel html, characters, xml file special characters, excel create xml, convert xml text, html copy excel, xml file excel, convert website language, excel convert html, converting website html, excel create xml file, excel create macro, convert text file xml, macro website paste excel

About the Employer:
( 3 reviews ) Helsinki, United States

Project ID: #2558681

16 freelancers are bidding on average $6/hour for this job

ZeusMan

Looking forward to working with you...

$8 USD / hour
(48 Reviews)
5.6
bouslimi1979

Please check PM. Thanks

$10 USD / hour
(31 Reviews)
5.3
mrbrave

Hi....NO sample file attached....Please send me one.

$8 USD / hour
(59 Reviews)
5.2
shanki161

Please Explain this.I will help you with [url removed, login to view] person here. Thanks Karan

$8 USD / hour
(9 Reviews)
4.3
expertatwork

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

$6 USD / hour
(16 Reviews)
3.6
manishadk

We can write macro for you. Please check PMB for details.

$5 USD / hour
(8 Reviews)
3.5
thilinapr

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!

$8 USD / hour
(3 Reviews)
2.3
ExtraNet

Quite straight-forward, send over your file for a final check and let's get this fixed ASAP.

$5 USD / hour
(3 Reviews)
1.9
AccuPro

Hello, I can help.

$8 USD / hour
(2 Reviews)
1.8
mukulsinha25

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 More

$4 USD / hour
(1 Review)
1.0
sorowakominded

i'am informatic in my subject i've no experience about this [url removed, login to view], 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 More

$5 USD / hour
(0 Reviews)
0.0
VSRawat

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

$8 USD / hour
(0 Reviews)
0.0
Locust

Hi, could you please send me a sample file? Thanks.

$5 USD / hour
(0 Reviews)
0.0
Masud191

I am interested to work, please send me details.

$5 USD / hour
(0 Reviews)
0.0
flowice

I'll create the macro for you.

$5 USD / hour
(0 Reviews)
0.0
JacobDuck

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. Tha More

$4 USD / hour
(0 Reviews)
0.0