VBA to mass replace UNICODE symbols to valid values

hmmmm....I don't think so. that seems VERY strange. It looks like what has happened here is that you got all the web information from a source that was reading the web code and it turned into obviously what you already know. ampersands resulted from ;gf, or whatever servers read. it's similar to that if you look at it in a dev IDE tool.

for some reason I can't open ur file with 2016.

Don't know why u cannot open it ;/ So there is no way to replace strange symbols ? or to compare with rows in 2nd table?

of course you can replace them! the question IS....do you have a pattern matching matrix/database to compare the messed up entries with? if you did, the solution would be very simple. so for instance, something like this to reference:

https://www.rapidtables.com/code/tex...haracters.html

I dont have any pattern to fix it, could You guide me how to do it? ( Like step by step)

well, without being able to open your file, I can't really do much! and I will not give step by step instructions. that goes against my belief that people can learn anything if they give effort when receiving guidance from me.

can you copy one of your worksheets to an ms word document, and post it up here? literally select all the data, copy it to the clipboard and paste it into word. the result will be a word table.

Ok i understand. File is attached in word file. Take a look You can open it. I'll try to do it of course just help me a bit

there is no file attached.

< edit >
ahhhh, I see it. stupid me! I'll get back to you if no one else jumps in to assist.

Thanks a lot, i will look forward your reply

can you answer the question in this image?

Of course, sorry my mistake, yes there is one &oacute~ that is problem. Rest is fine

Originally Posted by Vixx1

Of course, sorry my mistake, yes there is one ó~ that is problem. Rest is fine

no, there is not that string. it is technically:

Please Login or Register  to view this content.

so....with that being said, I have no idea how those symbols got in there for you, but they are NOT unicode. so...as far as I can tell, you're going to have to identify each one, one at a time and then put the in a list to reference. because obviously there is no table on any webpage that lists junk like that. sorry.