title: Replace multiple characters in a string variable (VBA)
body: <p>How can I replace more than one thing in a string variable?</p>
  
  <p>Here my example function in VBA:</p>
  
  <pre><code>Private Function ExampleFunc(ByVal unitNr$) As String
      If InStr(unitNr, "OE") &gt; 0 Then
          unitNr = Replace(unitNr, "OE", "")
          unitNr = Replace(unitNr, ";", "")
      End If
  ...
  End Function
  </code></pre>
  
  <p>Is there a better solution?</p>