title: Copy and paste formula result as value
body: <p>I wanted to know if able to paste the result of the formula below into a value in VBA. I would like to copy the formula from my temporary workbook and paste it in another workbook. </p>
  
  <p><code>=LEFT(C32,SEARCH("invoice",C32,1)-1)</code> </p>