title: VBA: newline and carriage return character for an Excel (.xlxs) file with Korean/French
body: <p>I'm having quite a bit of trouble replacing the newline and carriage return characters in an Excel file (2010 US version and .xlxs extension). </p>
  
  <p>Previously, I have written a macro that does this successfully on a regular Excel file with English with the following code.</p>
  
  <pre><code>newStr = Replace(originalStr, newline/carriage return/both, replacementStr)
  </code></pre>
  
  <p><code>Newline/carriage return/both</code> would be vbNewLine (Chr(10)), vbCr (Chr(13)), or vbCrLf, respectively.</p>
  
  <p>I now have an Excel file with Koreans and French in it, and the newline and CR characters seem to be something else. How do I go about finding what they actually are, in terms of <code>Chr()</code>) or some VBA constant, and replace these characters? I need to remove all of the newlines and replace with <code>&lt;br /&gt;</code>.</p>