title: Cannot delete non-space whitespace character in excel
body: <p>When bringing in data into excel via whatever method (import, paste, ...) I sometimes get the following issue. At the beginning of the cell there is an extra space in front of the text. Now I know the usual procedures to handle this namely:</p>
  
  <pre><code>trim(cell number)
  </code></pre>
  
  <p>and if its not a space character</p>
  
  <pre><code>=TRIM(SUBSTITUTE(cell number,CHAR(160),CHAR(32)))
  </code></pre>
  
  <p>But this time both of these didn't work. I did try other substitute CHAR's.</p>
  
  <p>AND the character at the beginning is just plain weird. When I go to the very beginning of the cell and try to delete it I must hit the delete key twice to remove one space! But when I go to the first character in the cell and instead hit backspace I only need to press it once.</p>
  
  <p>What else can I do to eliminate this weird non-space whitespace character?</p>