I have written a vba program in Excel that logs onto a website, navigates to an XML export file, and saves it to a network folder for processing by our AS/400. The problem is that occasionally a trademark symbol chr(153) is in the file and that causes the file to bomb out on the AS/400 because it does not recognize the symbol. Any ideas for a simple routine to remove the TM symbol or replace it with a space? I keep having issues with importing it into a worksheet and changing it there. It loses the XML format, mostly involving quote signs.