title: Replacing all occurences in a sheet full of excel formulas
body: <p>In an Excel sheets there is a ton formulas with references to another sheet:</p>
  
  <p>e.g. the formulas in the first few cells are written out here:</p>
  
  <pre><code>           A                                           B
  
     1      '[Another sheet 11.xls]Grill'!BD19            ...
     2      '[Another sheet 11.xls]Grill'!BF129
     3      '[Another sheet 11.xls]Grill'!AD29
     4      '[Another sheet 11.xls]Grill'!KA123
     5      ...
  </code></pre>
  
  <p>Is there any general way of going about replacing "[Another sheet 11.xls]" with "".</p>
  
  <p>The data was copied from another sheet to begin with hence the borked references. Is there any other way of telling excel to keep the references in the same sheet?</p>
  
  <p>xD Namaste</p>