title: Excel Hyperlink mass update
body: <p>I have a spreadsheet with thousands of rows. Each row contains a hyperlink with a path.</p>
  
  <p>The path is not valid, however easily fixable by replacing first part of it with correct value.</p>
  
  <pre><code>Example: current hyperlink: F:\Help\index.html
  
  Needed: P:\SystemHelp\index.html
  </code></pre>
  
  <p>The problem is that standard Find/Replace does not "see" content of hyperlinks.</p>
  
  <p>Is the only way to write a macro or is there another way to do it?</p>