title: Regular expression substring replacement in Microsoft Excel
body: <p>I would like to bulk replace the "07" part of a list of strings (mobile telephone numbers) with the international version "447".</p>
  
  <p>The list of strings currently forms a columnn in an Excel spreadsheet.</p>
  
  <p>I have the regular expression to match strings requiring modification:</p>
  
  <pre><code>^07[0-9]{9}$
  </code></pre>
  
  <p>...but I don't know how to do the replacement that I need.</p>
  
  <p>The data is in an Excel spreadsheet, but can of course be exported.</p>
  
  <p>Preferred solution would be to keep the data in Microsoft Excel, but it can of course be exported and then re-imported. I know TextMate has a regular expression replace feature. Can this help me?</p>