title: Excel Macro- remove a word that starts with certain characters
body: <p>In a VB macro for Excel, how do I remove all occurances of a word that starts with a certain string?</p>
  
  <p>Eg:</p>
  
  <p>The string reads: <code>xxxx $AUD543.43 yyyy</code></p>
  
  <p>I want to search for anything in a string that starts with <code>$AUD</code> and remove the whole word before the next space</p>
  
  <p>So the example above should result in:</p>
  
  <p><code>xxxx yyyy</code></p>