title: how to remove the space between number in datagridview vb 2010
body: <p><a href="http://i.stack.imgur.com/eF6lO.png" rel="nofollow">datagridview table </a>
  please can you help i have this problem i tried a lot of code but nothing work</p>
  
  <pre><code>Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As
  System.EventArgs)Handles Button4.Click
  
  For RowsCount = 0 To DataGridView1.Rows.Count - 2
  For Each dgvr As DataGridViewRow In DataGridView1.Rows
  If dgvr.Cells(0).Value.ToString = " " Then
  dgvr.Cells(0).Value = ""
  End If
  Next
  Next
  End Sub
  </code></pre>
  
  <p>what want to do is to remove the space between all number in the column Tel
  and remove the zero and left i want all number to be like this without space or 0 like this 48802967 so please can anyone help i'm new in coding</p>
  
  <p>the DataGridView is loaded from a mysql database</p>