title: csv carriage return don't show up in Excel
body: <p>I want to import a csv file in Excel. The csv file has carriage returns but Excel don't show them (see picture 1). The carriage return only comes up when i select the text in the cell and press enter. </p>
  
  <p>Is there a way to solve this automatically? (vba)</p>
  
  <ul>
  <li>I've tried to substitute the carriage return by a semicolon, but Excel does not find the carriage return. (=SUBSTITUTE(F2, CHAR(10), ";")</li>
  <li>Text wrap is turned on in the cells</li>
  <li>I tried to find the carriage return with a macro and the "instr()" function but Excel does not find the Chr(10).</li>
  </ul>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-css lang-css prettyprint-override"><code>Sub FindCarriageReturn()
  
  myPos = InStr(1, Range("F2"), Chr(10))
  
  End Sub</code></pre>
  </div>
  </div>
  </p>
  
  <p>All documents: <a href="https://drive.google.com/open?id=1Kwr1VjCSdxtbtNcM6h5Rl8tc_Mo9XIA6" rel="nofollow noreferrer">https://drive.google.com/open?id=1Kwr1VjCSdxtbtNcM6h5Rl8tc_Mo9XIA6</a></p>
  
  <p>Thanks in advance!</p>
  
  <p>Dieter</p>
  
  <p><a href="https://i.stack.imgur.com/8nBI3.png" rel="nofollow noreferrer">picture</a></p>