Thread: [Solved] Search and replace symbols
View Single Post
 
Old 05-26-2019, 06:14 PM
Chayes Chayes is offline Windows XP Office 2003
Advanced Beginner
 
Join Date: May 2012
Posts: 79
Chayes is on a distinguished road
Default Search and replace symbols

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
File Type: doc Sample.doc (24.0 KB, 8 views)
Reply With Quote