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,
16 freelancers are bidding on average $6/hour for this job
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 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