title: Coping from .txt file to excel I lose about 1340 lines from 61787, where do they disappear to?
body: <p>The txt file is filled with data I've extracted from some json's in this format:</p>
  
  <pre><code>filename|title_of_article
  </code></pre>
  
  <p>I've made sure that all of them have a title so no empty strings there.</p>
  
  <p>When I copy this information into excel with the text to columns option set to "|" only.</p>
  
  <p>The information is split properly into 2 columns however I end up losing about 1340 lines along the way. How does that happen?</p>
  
  <p>When I do the same but do not set the Text to column options beforehand I copy everything to excel. I lose no lines.</p>
  
  <p>Where does this problem come from?</p>
  
  <p>I ran a vlookup and here are some of the lines that didn't copy in the first way:</p>
  
  <p><a href="https://i.stack.imgur.com/Kqgn6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Kqgn6.png" alt="enter image description here"></a></p>
  
  <p>as far as I can see there is nothing special about them.</p>