title: Replacing dots with space
body: <p>I am trying to replace dots  with space and it is working, but it is also replacing values that has commas. </p>
  
  <p>Example
  1.506,45
  is transformed to
  1 506,45</p>
  
  <p>but
  1,506,45
  is transformed to
  1 506,45</p>
  
  <p>and it is ruining the values.
  Any ideas how to replace ONLY dots and not commas?</p>
  
  <pre><code>ActiveSheet.Columns("A:A").Select
  
  Selection.Replace What:=".", Replacement:=" ", LookAt:=xlPart, _
  SearchOrder:=xlByRows, MatchCase:=False
  </code></pre>