title: Excel VBA code to replace empty cell with adjacent (column) cells
body: <p>I have an Excel file where some of the column information is blank. I want to fill the blank cells with information from the two columns that come after the empty cell. For instance:</p>
  
  <p>Column E is the full name of a person. Column F is their first name, Column G is their last name. </p>
  
  <p>So, if E is blank I want to combine the contents of F and G into E. </p>
  
  <pre><code>1 JOHN JONES  | JOHN  | JONES
  2             | MARY  | FORD
  3 FRED MURPHY | FRED  | MURPHY
  4             | TONYA | FARMER
  </code></pre>
  
  <p>I want the code to populate the empty cell in row 2 with 'MARY FORD' and row 4 with 'TONYA FARMER'. </p>
  
  <p>I'm using Excel 2010 and have tried different combinations but nothing seems to work the way I want it to.</p>