title: Remove Formula but keep data with source formatting?
body: <p>Remove Formula but keep data with source formatting ?</p>
  
  <p>I have excel data on which couple of columns have formula. I need to remove the formula but keep data intact with formatting.</p>
  
  <p>Everywhere on google below solution is given </p>
  
  <ol>
  <li>Select the cells with formulas you want to remove but keep results, press Ctrl + C keys simultaneously to copy the selected cells.</li>
  <li>click Home > Paste > Values </li>
  </ol>
  
  <p>But its not keeping the source formatting like Merged cells etc.</p>
  
  <p>Then instead of doing  <code>click Home &gt; Paste &gt; Values</code> I did <code>click Home &gt; Paste &gt; Values and Source Formatting</code> but it is still keeping formula</p>
  
  <p>How can I remove the formula but keep data intact with source formatting ?</p>
  
  <p>Update :- Screen shot based on Tim answer</p>
  
  <p><a href="https://i.stack.imgur.com/yafVh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yafVh.png" alt="enter image description here"></a></p>