Mar 25

Replacing Non-Printable Characters

Although Word allows you to search and replace non-printable characters, such as line feeds and carriage returns, it's not as easy in Excel. This line of code will does the trick, though. In this case, it replaces carriage returns with the HTML line break tag: Selection.Replace What:=Chr(10), Replacement:=”<BR>” If you simply need to eliminate non-printing characters, use Excel's Clean function.