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 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön
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!
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