title: Excel Macro to concatenate
body: <p>Need help in creating an Excel Macro.I have an Excel sheet.The Excel sheet is not consistent.
  I am planning to make it uniform and structured.</p>
  
  <p>Eg.</p>
  
  <pre><code>  A            B            C         D
  1 test      tester         tester
  2 hai       test
  3 Bye       test           tested
  4 GN        test           tested    Fine
  
    A            B            C         D
  1 test      testertester   
  2 hai       test
  3 Bye       testtested     
  4 GN        testtestedFine 
  </code></pre>
  
  <p>Basically I have to find the last cell where element is placed so based on that I can write my CONCATENATE funciton.</p>
  
  <p>In this case it would be Column D and hence my concatenate function would have been
  =CONCATENATE(B1,C1,D1)
  Again I would like the result to be in B1 but not a problem if I have to hide.</p>
  
  <p>Can anyone help me in doing this?</p>