title: Excel cell has an invisible character
body: <p>I was trying <code>VLOOKUP</code> between two different Excel sheets, but it always returned <code>#N/A</code>. I found out the problem is on the lookup workbook (second workbook); the value in the cell is a string of alphabets of length 9. But when I use the <code>=len(A1)</code> formula, it shows <em>10</em> characters. So I used <code>TRIM()</code>, but it still shows 10. Then I used <a href="https://stackoverflow.com/a/9582919/3025856%22">the following answer</a> on &quot;https://stackoverflow.com/questions/9578397/remove-leading-or-trailing-spaces-in-an-entire-column-of-data&quot; :</p>
  <blockquote>
  <p>Quite often the issue is a <strong>non-breaking space</strong> - <code>CHAR(160)</code> - especially from Web text sources -that <code>CLEAN</code> can't remove, so I would go a step further than this and try a formula like this which replaces any non-breaking spaces with a standard one</p>
  <pre><code>=TRIM(CLEAN(SUBSTITUTE(A1,CHAR(160),&quot; &quot;)))
  </code></pre>
  <p>Ron de Bruin has an excellent post on <a href="http://www.rondebruin.nl/win/s9/win017.htm" rel="nofollow noreferrer">tips for cleaning data</a> here</p>
  <p>You can also remove the <code>CHAR(160)</code> directly without a workaround formula by</p>
  <ul>
  <li><em>Edit .... Replace</em> your selected data,</li>
  <li>in <em>Find What</em> hold <code>ALT</code> and type <code>0160</code> using the numeric keypad</li>
  <li>Leave <em>Replace With</em> as blank and select <em>Replace All</em></li>
  </ul>
  </blockquote>
  <p>Still it shows 10 characters, instead of 9. Please help.</p>