VBA not replacing CHR(13), still displays a bunch of white - Microsoft Community
Chr(10) or vbLf (if you want to use the built-in constant) is a Line Feed character. Chr(13) or vbCr (if you want to use the built-in constant) is a Carriage Return character. Just so you know, many Windows programs use a combination of Chr(13) & Chr(10) ...