title: converting formula result to string using excel VBA
body: <p>i am working on a project which requires me to spit out data from access onto an excel and then finally export into SQL after doing some calculations in excel. When i get the data from Access into excel i am using excel formulas like </p>
  
  <pre><code>=RIGHT(F87616,4)
  </code></pre>
  
  <p>and</p>
  
  <pre><code>=IFERROR(MID(F87616,1,FIND("-",F87616,1)-1),"")
  </code></pre>
  
  <p>Now, what i want to do is, replace this formula with result of these cells so that when i export from Excel to SQL, i can pick up this data as a string. </p>
  
  <p>I know it may sound very confusing but basically i am trying to replace the formulas with the result that i would get after calculating values using the formulas. Any help is appreciated.</p>