title: How to remove a single Leading space in the numeric column in Excel 2013
body: <p>I really tried a LOT with in-built functions and also with google search but none of the ways doesn't worked out for expected result.</p>
  
  <p>My exact problem is:
  I've few numeric columns which i got from a website and copied directly into excel.</p>
  
  <p>In those columns there is a SINGLE Leading space at the beginning of each number in the cell of the entire column. Example <code>523946.00</code>. In this number there is a single space before the digit <code>5</code>.</p>
  
  <p>I tried a lot with TRIM and SUBSTITUTE in-built functions but nothing able to resolve my problem of removing spaces.</p>
  
  <p>And also my <strong>expectation</strong> is when i select two or multiple cells in the same column(spaces removed) then automatically Excel should show or display the <code>AVERAGE: &lt;Average value&gt;  SUM: &lt;total Sum&gt;  COUNT: &lt;count value&gt;</code>  at the below status bar or bottom ribbon. </p>
  
  <p>Say, <code>AVERAGE: 175.49 COUNT: 2 SUM: 350.98</code></p>
  
  <p>This type of information is not showing at the bottom. Only i'm able to see <code>COUNT: 2</code> alone....why? 
  I want in General Format only. No any special formats.</p>
  
  <p>I'm using MS Excel 2013</p>