title: I need to Concatenate the values and separate with "|" but ignore blanks
body: <p>I should start by saying I'm new at this, but I've been asked to get something done at work. I'm using Excel 2008 on a Mac.</p>
  
  <p>I've created a data set that is roughly 3000 rows x 95 columns. the first column is a concatenation of product descriptions, manufacturers, etc. The rows are a list of keywords that I've used the following formula to identify and display in each of the 3000 rows:</p>
  
  <pre><code>=IF(ISNUMBER(SEARCH(C$3,$A3)),C$2,"") . 
  </code></pre>
  
  <p>This has left me with data scattered throughout the sheet. I now need to combine the data from each row into one cell, with each discovered keyword separated by <code>|</code>, but I need to ignore blank cells so that I have a result like the following: </p>
  
  <pre><code>Keyword1|Keyword3|Keyword4|
  </code></pre>
  
  <p>and not like this: </p>
  
  <pre><code>Keyword1||Keyword3|Keyword4|||||||||||| 
  </code></pre>
  
  <p>Anyone have any ideas? </p>
  
  <p>Thanks</p>