title: How to resolve excel error 2029 with #NAME?
body: <p>I read an excel file and on a cell I got a text like this:</p>
  
  <p><code>"=- Bla Bla Bla".</code> 
  This will not be recognize and will show <code>#NAME?</code></p>
  
  <p>So if you need to read some cell and get it into database this error in the file will show as <code>Error 2029</code>. The script will freeze.
  So, can I pre-replace the content if I get <code>=</code> or <code>-</code> chars in the cell so I validate the content before I read it and get the error. Can I pass over it!</p>
  
  <p>I need cell validation</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      c = Target.Cells.Column
      r = Target.Cells.Row
      'validate cell
  End If
  </code></pre>
  
  <p>Thank you!</p>