title: Convert automatically excel table formulas from explicit cell reference to structured cell reference?
body: <p>I have an excel table with formulas such as </p>
  
  <pre><code>=M9-C9*10-D9*10-C9*H9/100
  </code></pre>
  
  <p>I want to convert these formulas to use structured cell references that use the table column names in the formulas, like this fake formula:</p>
  
  <pre><code>=[Sales Amount]-[Profit]*10-[Costs]*10-[Profit]*[Risk]/100*10-[Capital]*[Gross]/100
  </code></pre>
  
  <p>Is there a way to automatically convert all the explicit column names (M9) to use structured references ([Sales Amount]).</p>
  
  <p>It is error prone to go through and manually do it.</p>
  
  <p>(Info about <a href="https://support.office.com/en-us/article/Using-structured-references-with-Excel-tables-f5ed2452-2337-4f71-bed3-c8ae6d2b276e" rel="nofollow noreferrer">Using structured references with Excel tables</a>)</p>