Hi All


I've been writing some VBA to search and replace the random symbols which sometimes show up in emails. It effectively clears these out to leave a clean text.



This works well to a point , but always leaves certain symbols which refuse to be cleared. There is one which is particularly stubborn. I can copy the symbol from the page , but when I try to paste into the search and replace dialogue , they fail to paste.



I wonder if someone with greater expertise would be able to advise on a way to clear these symbols.


I've attached a sample file that shows the offending symbols.


Grateful for any help.

Attached Files

Sample.doc (24.0 KB, 8 views)