title: Concatenate time as text in Excel but ignore blank values
body: <p>I have several columns I am trying to join in Excel, including a date and time.  All of the rows have dates but a lot of the time values are blank.</p>
  
  <p>At the moment I have the following formula:</p>
  
  <pre><code>=CONCATENATE(TEXT(B2,"dd mmm yy "), TEXT(C2,"[h]:mm"))
  </code></pre>
  
  <p>This works fine when I have a date and time (eg 13 Nov 16 10:50) but if the time column is a blank value I get a result as midnight (eg 13 Nov 16 0:00).</p>
  
  <p>How can I ignore blank values so that the result displays (13 Nov 16)?</p>