title: excel vba - concatenate two cell's content to another
body: <p>I have two columns that I need to combine an place in a third column. I've tried <code>=CONCATENATE(A1," ", B1)</code> but the result is wrong (it turns into some integer). Also, I need this in vba code cause I'm trying to automate something.</p>
  
  <pre><code>Column A   | Column B | 3rd column Desired result
  2018-02-03 | 01:03:22 | 2018-02-03 01:03:22
  2018-01-01 | 13:44:22 | 2018-01-01 13:44:22
  2018-04-11 | 20:44:43 | 2018-04-11 20:44:43
  </code></pre>