Need help finding all non ASCII characters in spreadsheet

[MAP-Daniel]

Happy Friday!

We recently signed a new customer which will email us a CSV file weekly containing 33,035 rows of data with ten columns of various information (name, department, email address, etc.) The issue is that this spreadsheet contains non-ASCII characters such as ╚, þ, and others. We can not copy and paste the spreadsheet into our system because it rejects these non acceptable symbols.

I am looking for a macro which will 'Find All' instances of these characters so we can manually replace each instance with the proper spelling of the individual's name. I don't want to remove these characters since Os©ar will then become Osar.

I tried my best to search for a good macro both on this site and on others but I utterly failed. So I apologize in advance if this question has been answered ad nauseum.

Dan

[protonLeah]

The code below will highlight the found cells yellow. You should consider a lookup/replacement table:

Please Login or Register  to view this content.

[MAP-Daniel]

protonLeah,

Thank you very much for the macro!

I didn't type out my request very well because I still needed common symbols like ( or @ to be ignored. But after tweaking your code to 'If CharCode < 32 Or CharCode > 122 Then', the macro works like a champ! I greatly appreciate your courtesy and I will ensure that all my co-workers and friends are aware of this site! Solved!

Kindest regards,

Dan