title: How to Copy & Paste Formula from Merge cell with out skipping a column
body: <p>I am trying to copy the formula in a merged cell and paste to the next cell.
  Since it is merged and contained 2 columns, the formula skips one column.</p>
  <p>When I copy C3 and paste formula to E3, the formula shows like below.
  <a href="https://i.stack.imgur.com/bkG33.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bkG33.png" alt="enter image description here" /></a></p>
  <p>However, it should be like this.
  <a href="https://i.stack.imgur.com/bLJdw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bLJdw.png" alt="enter image description here" /></a>
  So the result should be this..
  <a href="https://i.stack.imgur.com/bnDd4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bnDd4.png" alt="enter image description here" /></a></p>