title: Removing decimal point in character string in Excel
body: <p>I have a character coding system in excel below is an example. What I want is to remove the decimal point (note that the decimal points are placed at differenr location and some without any decimal point). </p>
  
  <p>The first column is what I have while the second column is what I desire.</p>
  
  <p>Thanks</p>
  
  <pre><code>Code    Desire
  AA1.50  AA150
  BB2.44  BB244
  B11.36  B1136
  CC1.98  CC198
  CC1.4   CC14
  CCC     CCC
  D00.0   D000
  Z00.1   Z001
  A00.9   A009
  </code></pre>