title: Remove white space at the end of text in Excel
body: <p>I have a large number of data in excel, which have whitespace in end of text. </p>
  
  <p>Example : </p>
  
  <p><code>"Lorem ipsum "</code></p>
  
  <p>or</p>
  
  <p><code>"Lorem ipsum             "</code>     </p>
  
  <p>How can I remove the whitespace?</p>
  
  <p>Result : </p>
  
  <p><code>"Lorem ipsum"</code></p>
  
  <p>UPDATE : </p>
  
  <p>I look the answer and worked for normal whitespace, i did research and found my whitespace is a unicode character. So i use this method and worked. </p>
  
  <p><code>=TRIM(SUBSTITUTE(Lorem ipsum             ,CHAR(160),CHAR(32)))</code></p>
  
  <p>Thanks.</p>
  
  <p>Source : <a href="http://office.microsoft.com/en-001/help/remove-spaces-and-nonprinting-characters-from-text-HP010062743.aspx?CTT=5&amp;origin=HP010062581" rel="nofollow">http://office.microsoft.com/en-001/help/remove-spaces-and-nonprinting-characters-from-text-HP010062743.aspx?CTT=5&amp;origin=HP010062581</a></p>