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